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