>Assuming a StockItems Table and a Transactions Table. If I want the Transactions Table to have a Foreign Key into the StockItems, and the StockItems to have a foreign keys into Transactions, there's no way I will be able to add a record in both tables (some Transactions will add StockItems) during the same transaction if I make both Foreign Keys non nullable.
>
>a) Is there?
>b) Is it ok the set foreign keys nullable?
>c) Is it not best practice to cross reference like this?
>d) is there anything else wrong in my reasoning?
Someone might jump in with a reply, but I want to ask this to confirm.
Can you post the table structure for both tables, and confirm what your PK/FK relationships are?
Thanks