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