SQL Server Best Practices Table Linking -

i new sql server , wanting make sure using best practices. doing creating 7 tables.

(transaction,customer,business,vehicle,seller,lien,mailto)

transaction main table creates transactionid. in other 6 tables have transactionid column can link them together.

in other 6 tables each have there own id well.

for example

(customerid, businessid, vehicleid, sellerid, lienid, mailtoid)

my question in transaction table have list of ids or having transactionid allow them connect.

transaction table 1 example

id type datetime

transaction table 2 example

id type customerid businessid vehicleid mailtoid sellerid lienid datetime

(for transaction id wanting created , automatically fill same in other tables fields submitted using foreign keys believe)

any on appreciated!!

do have list of ids- no!.

having "transactionid" allow them connect.

UV code