Update: So, I created a script that now finds the results of what I'm looking for. I'd now like a field to be calculated based on the amount of records found in that script (and do so and update automatically, of course). Any thoughts on accomplishing that?
You don't need a script, but I recommend against matching by name to count the number of awards that a person receives. What if the person gets married and changes their name?
Instead, match by a serial number ID unique to each person and then name changes and duplicate names will not be an issue.
Let's assume that you have these tables and relaitonships:
Employees::__pkEmployeeID = Awards::_fkEmployeeID
For explanation of the above notation, see: Common Forum Relationship and Field Notations Explained
Modify this to create:
Awards::_fkEmployeeID = AwardsSameEmpID::_fkEmployeeID
To create AwardsSameEmpID:
In Manage | Database | relationships, make a new table occurrence of Awards by clicking it and then clicking the duplicate button (2 green plus signs). You can double click the new occurrence box to get a dialog to appear where you can rename the new occurrence box to be AwardsSameEmpID.
We have not duplicated a table. Instead, this is a new reference to the same table already present in your database.
Now, you can use Count ( AwardsSameEmpID::_fkEmployeeID ) to count the number of awards that a given employee as received. Also, you can define a summary field, sAwardCount, in Awards as the "count of" _fkEmployeeID and then you can refer to AwardsSameEmpID::sAwardCount to get the same count of how many awards that a given emplyee has received.