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...