AnsweredAssumed Answered

Keeping related records up to date

Question asked by makj1 on Dec 9, 2016
Latest reply on Dec 13, 2016 by philmodjunk

Hello, I've got a question about reconciliation of a field in my database. To set up the question, I've got a DB with let's say 3 tables. Table 1 holds all user information and has a field (pk_userid) and Table 2 and 3 each have another user id field (fk_userid). The parent key is a unique ID used to reference any records in any of the other related tables. My issue is with trying to reconcile all the entries for this field. I have a very rudimentary script that Freezes the layout and copies the userid field, goes to the other layouts and copies them. It seems to me that there would be easier ways to keep these up to date so when a new user is added in Table 1, Filemaker can add the userid to the other tables. Any guidance or help is appreciated. Thanks!