Table Occurrence question
I would like to place a portal on the Volunteers form that lists all Volunteer activity for the current year, and counts the number of activities this volunteer attended. Perhaps a second field that gives a grand total of their activity.
Based on diagram, do I need a calculated field in Volunteer Activities that counts the Volunteer ID’s where the fkVolunteerID is = to pkActivitiesID?
Also do I need a table occurrence? Since all tables are already related, not sure I do. If so would it be based on Volunteer Activities?