>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

No, this is not because of this problem. You probably didn't insert records in the right order.