I have a table of people (around 2000 or so) and a table of education records (45,000+). Most of those are imports from previous app. The new ones, I have it set when created a new education record, that you can connect to multiple people at once, say if a class is held with 30 students, instead of adding them individually.
We track the education hours received of the people and need to make sure they hit a certain number. All of it works fine when an education record only has one person connected, by adding a date calculation to find the difference between the date the education record was completed and the date in which their hours count toward their totals. There are two possible solutions in my mind,
-
roll up field on the person table that checks if Date Completed on the education record is after the particular date listed on the person. This functionality is broken right now and after my mention to support, they’ve removed that option entirely.
-
some kind of form rules to duplicate the record for each person that is connected. I have no idea how to accomplish this. If this is the better approach, any ideas on how to do this would be greatly appreciated.