Well, glad you got around it. I'm guessing that the problem tables were being processed before their appropriate parent tables. By moving them to the "end of your list", you gave the parent tables a chance to be processed first.

~~Bonnie



>I am not using transaction that I know of, just sql pass-through. I finally got everything to work. I had to move the erroring tables to close to the bottom of my list of tables to go through and got it to quit complaining.
>
>Thanks for your suggestions and help.
>Beth
>
>>Are you using transactions? Has the table containing the PK's actually been committed prior to entering the child tables' records?
>>
>>~~Bonnie
>>
>>
>>