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