ArdeviaForum

Populate sub-list item columns with list item column values - When form is saved I need to duplicate some of the list information on to the sub-list information

Discussion created by ArdeviaForum on Aug 19, 2016
Latest reply on Aug 19, 2016 by ArdeviaForum

Original Post by Sandy (Imported from Ardevia Forum)

Hi,

 

I have an Invoice List and a Lines list that are related via a column on the Lines list (IID) that has a lookup to the ID column on the Invoice List.

 

I want to take the Lines list and import that into our Finance System and have included some extra columns on this list that I want to populate with the value that exists on the Invoice List.

 

Invoice List

 

ID
Invoice_x0020_Date
ETL_x0020_Status
 

 

Line List

 

ID
IID - (lookup to Invoice List ID)
Inv_x0020_Date
ETL_x0020_Stat

 


Invoice_x0020_Date should also populate each Line list (Inv_x0020_Date) related to the Invoice.

 

ETL_x0020_Status should also populate each Line list (ETL_x0020_Stat) related to the Invoice.

 


I have tried adding an action to my Save button to update the list item, but it can't find the ID on the sub-list. This action is placed after the Save Form action.

 

Any help you could offer would be appreciated.

 

Thanks
Sandy

Outcomes