Hi all...

Using VFP 5.0a on WinNT 4.0 sp3, I am having a problem with referential integrity of my database not working properly.

My db consists of a parent table (parent) and three child tables (child1, child2, child3). Each parent - child relationship is a one to one relationship using the same candidate index field (myKey). The myKey field in each table is the same type and length (character, 20).

I have referential integrity set up so when a record is deleted in the parent table that any related records in the child tables are deleted also (cascaded). On two of the child tables, this works fine. However, on one of them (child1) (perhaps I should call it 'problemChild1') is doesn't work. The record in child1 which corresponds to parent is not marked for deletion.

BTW, the Referential Integrity Builder dialogue box does show that all three parent-child relationships are set to 'cascade' for 'rules for deleting.'

What could cause this? I've tried reseting all the referential integrity rules to 'ignore', saving it, going back and changing to 'cascade,' but no change. I've tried deleting the index in child1 and recreating it, but also no change.

I've looking in MS Dev Net, but nothing there. I suppose if I have to, I could change my app so that when I delete a parent record, I delete the child record, but I think I'd rather have the dbms handle this.

Thanks in advance,
Marc Mandel