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.
With this relationship:
Donors::DonorID = Donations::DonorID
You can define a calculation field in Donors with this expression:
Count ( Donations::DonationID )
will compute the total number of donation records for any given donor.