>>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.

Thanks for that Naomi.

Made me look back at the obvious

a typo :-(