Transaction Foreign Key

Hi everyone,

I need to make a transaction that inserts some data into table 1 and table 2. The problem is that col2 of table 2 is col1 of table 1 and col2 of table2 has a foreign key constrain on it. The problem is when it goes to insert the data in table2, it goes and looks in table 1, but since the transaction is not committed and this point, it throws an error. Is there any way to make it look until the transaction is commited. I have read something about DEFERRABLE, but I haven't seen any sample that works.

I am using SQL Enterprise Manager 8.0.

Thank you!