I have a table called 'Workorder' with a field called 'Description'. Each workorder record has 1 description field.
I have a table called 'Workorder_Instructions' that has a 'qty' and 'parts' field. There can be multiple 'instruction' records per workorder.
What I would like is for the 'Description' field in the 'Workorder' table to be a result of the qty and parts fields concantenated into 1 string PER instruction record.
For example: Workorder # 999 has 2 instruction records, 1 has qty 4 doors and the other has qty 2 drawers. I want the description field to show '4 doors, 2 drawers'. I would like it to be active so as users enter in more parts to the instruction table, the description field in the workorder is updated as well.
Thanks for your help!