

Store only primary keys in that active records table and link it to the real data table via a one-to-one relationship. The new table has only the one primary key – all other data is pulled into the layout from the table with containing the data through the relationship:įinally, the most elegant solution: create a new ‘active records’ table and put it in front of the real data table. The secret is to put new related table in front of the table with the data, and relate the new table to the old table based on the primary key. Instantly Restore Deleted FileMaker Records? How is that possible? As it turns out, it’s not that all that hard, but does require some up front planning.
