Well Thanks for bouncing it around, I'll probally just keep my work around in place and hope I don't encounter this problem again.




>i'm out of ideas. usually those are the 'problem' areas w/ vfp-generated RI code.
>
>>Character fields, they hold Ids such as RSO_005. Both fields are of size 10 as well.
>>
>>
>>
>>
>>
>>>numeric or character fields?
>>>
>>>>I knew what you meant, just answered incompletely, nope no composite keys used in the relationship
>>>>
>>>>>i mean composed of multiple fields.
>>>>>
>>>>>>Nope, Primary Index in the Parent Table, and a regular index in the child table.
>>>>>>
>>>>>>
>>>>>>
>>>>>>>are the relations set on a compound or composite key?
>>>>>>>