I have a log process that logs system events for all Students by creating instances of Student.Milestone_Log. Each Student.Milestone_Log entry is owned by Student which is also stored in Student_Milestone_Log.Student
Users can filter the log to review history info, then select certain Students to run a Mail Merge or Email Merge. Students can be selected on the following query by checking the Student_Milestone_Log entries & clicking "Add to selected students"
- log entries.jpg (68.12 KiB) Viewed 2550 times
INSERT Student_Milestone_Log.Student IN LoggedInRegularUser.Students_Selected
I thought I was going to have to do a FIND to get to the Student instances related to each log entry, but that was not necessary.