I just want to confirm if I'm misunderstanding something - take the following example:

I've a table called "DealSide" whose primary key is "ID+Side" (both character fields). I also have numerous children tables that have the same ID and Side fields for their primary key. The RI is set up between the primary tag of DealSide and the corresponding children tables.

If I update the Side field in the DealSide table to be another value, the update doesn't cascade to the children. So, I dove into the RI code in the DBC and noticed that within the SCAN / ENDSCAN block for each child table, there is no code that calls the RIUPDATE() proc to do any updating. Since the Side field is part of the primary key, shouldn't that be considered a valid change that should cascade down to the child tables?

Laterness,
Jon