Hi I am building an order intake form that will have information submitted belonging to 3 tables. The order table will have the primary key used for the property and customer table.
How can I simultaneously create the primary key via the identity on the order table and insert that into the property and customer table?
Order OrderKey PK
Property OrderKey FK