Multiple Estimate Versions
What are some recommended approaches to creating estimate version? Here is the breakdown:
Currently, there is a RecordID (serial) for each job with it's associated LineItems. What I would like to do is have a table "EstimateVersions" containing the fields:
When a user wishes to create a new version of the job, they execute the script and the following happens:
Not quite sure how to go about scripting this whole bit. The new version part isn't a problem, it's the duplication of records and their reference of the new Estimate Number and also their respective RecordID's (serial) that I am lost on.