Duplicating a record that is linked to several tables
I have a work-order system that links two tables together...the main table links to customer info (one to one link); parts info line-item (one to many link). That is three tables total,
=> Line Items
=> Customer details.
I can not find a way to duplicate a workorder when a job repeats, meaning I need to duplicate one record in the main table, no duplication in the Customer table, and I need to duplicate a range of records from the Line Item table.
All of my scripting attempts have failed (scritping is still my one greatest FM weakness), are there any other ways to do this? Or can someone offer some tips on how to make my (weak) script work?
Am I even making sense? Can someone recommend a solution ot point me in the right direction?