>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?
Hmm I may have come up w/the answer. Maybe it's because the Side field is part of a compound key, so that wouldn't filter down by itself..?
Jon Rosenbaum
Devcon Drummer