Hi all,
I have a table with one entry for each Job.
There are two other tables, Labour and Parts.
Labour and Parts could have many rows relating back to Job 1 for example.
I would like to copy Job 1 and copy all of its related labour and parts rows.
(I would change their Key columns so they are seperate entries)
I have step one working. I can copy a row from Job and I adjust its Key column value and keep all other required information using an action called "Data: add a new row to another table using values from this row"
I cannot find a way through actions to copy its related rows and change them?
Can someone point me in the right direction on how to do this or if actions simply cannot achieve this?
LinkedIn
Twitter
