HI

I'm inserting records into several tables.

I've wrapped all the inserts in a transaction as I don't want any of them to work if one fails.

I'm getting a foreign key error on one of the inserts.

Is this because the transaction hasn't been committed so effectively the foreign key doesn't exist

Thanks

Nick