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?
>>
>>>I have a database set up with the relation between two table to cascade deletes; however when I delete a record form the parent table the records in the child remain. I've goten around it by writing a procedure to go into the child table and delete the matching records, but would rather not have to do this. I even tried deleting the all of the RI procedures and then letting foxpro regenerate them, but this had no effect. Has any one else seen a problem like this?
>>>
>>>Also why I'm on the subject of the RI procedures, does anyone else besides me find them to be a pain to read?
>>>
>>>Thanks for any input.
>>>
>>>-Preston