AnsweredAssumed Answered

Referential Integrity / Cascade Changes

Question asked by brodlang on Feb 13, 2012
Latest reply on Feb 13, 2012 by philmodjunk

Title

Referential Integrity / Cascade Changes

Post

I'm working on a DB for doors. Tables include Location, Materials, Frame, GeneralInfo and many other related tables. I'm converting from a Paradox database and had many and one-to-one relationships with referential integrity and cascading changes. Being new to FMP, I'm trying to figure out how to "cascade" a field. E.g. = door number 21A has a name change to door # 21B.  I need related tables to automatically update and stay in sync so they won't get orphaned. I'm not a pro but I had good luck with Pdox (while it lasted). Any help is appreciated.  Thanks.

Outcomes