Here is the scenario:
Service Order Header and Service Order Detail tables linked with a One to Many relationship and referential integrity and cascading rules enabled. Once the Service Orders are completed I'd like to Copy them (some values) to the Invoices Header and Invoices Detail tables to be used for generating Invoices. Invoices header and Invoices Detail are also linked with one-to-many and referential integrity and cascading rules enabled.
I know this must be a common scenario but I can't easily find the solution. Rather than beating my head against it only to devise an improper solution I'm asking this forum for assistance.
Thank you in advance for your assistance.
Regards,
Jason