Hi I am trying to update a record in one table from another
For instance i have three tables
Invoices Customers Data
I have the invoices and the customers talking and i can pull from the data table to the invoices table. However i want to update the item in the data table with who bought it etc.
From what i have read you need to do workflow actions but am confused