Referential Integrity / Cascade Changes
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.