Thanks Gerry for your input:

Are you suggesting to keep all records (estimates and archived) together only they would have restrictions based on their status code and depending on their permissions users are allowed accesss to process certain records. This may have some merrit.

There is still the issue of the invoice total being based on calculations from the link between order records and code file which if archived records
maintained would change the invoice total when prices change in the future.