I have a table titled “BIO” where I’ve made records for each player on a football team. I also have a “REPORT CARD” table that includes a record for each player and a field for each player’s grade and a field for the players GPA dependent on their grades. This GPA is used as part of a disciplinary points system for the team. Points are stored in a separate “POINTS TRACKER” table.
I’ve created a ZAP so that when a new record is added to the BIO table, a new record for that specific player is also added to the other tables.
My problem is this: I used a linked field to connect the REPORT CARD and POINTS TRACKER tables. This allows me to pull that GPA score into the points tracker to be used to calculate a points system score for each player. However, when I add a new record, this linked field does not update the linkage for the new record. Any tips are appreciated!