AnsweredAssumed Answered

Table Occurrence question

Question asked by Striker3070 on Jan 12, 2014
Latest reply on Jan 15, 2014 by philmodjunk

Title

Table Occurrence question

Post

     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?

real1.png

Outcomes