Track number of records in a table in a field in a different table

Discussion created by MarkHarrison on May 3, 2017
Latest reply on May 3, 2017 by philmodjunk



In the donations database I needed help with earlier I have a more basic question (I think).  In my DONORS table, I'd like to have a field that indicates the total number of collective donations the person has made. I figure that the easiest way to do this without having to manually update it each time the person makes a new donation is to have the field look at the DONATIONS table and see how many records there are with that person's DonorID attached to it. But how do I do that? I have not done scripting before, nor have I used calculation or lookup fields.  So far, I have not figured out the syntax for scripting to know how phrase instructions in a script with proper punctuation, etc.