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