Original Post by Sandy (Imported from Ardevia Forum)
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.
IID - (lookup to Invoice List ID)
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.