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?
>>>
>>>>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
Preston A. Larimer palarimer@usa.net
Olive LLP