Coordinated Transactions

I have a block group that writes about 10,000 rows to MSSQL. I also have Order information that I want to write to a separate table and include the “Block_ID” to link the two tables together. Currently I am writing everything to the same table thus, duplicating the order information 10,000 times. All of the data originates in the PLC.

Any suggestions?