I have a sporting club that meets on multiple nights with different members and different locations. I have defined tables for clubs, members and lessons (a club night) but I need to quickly record which active members have attended on a night. This record keeping is essential from a child protection standpoint.
I can bulk select rows from a view of active members for a club location but there is no way I can see to save this into a separate attendance table for the lesson. Creating a column for each lesson on a member table does not appeal and manually adding each person will be too slow to be usable (I think).
I have searched and this appears to have been mentioned previously and is not possible but I should have thought there would be a great many applications of this “bulk add into a separate table” function? What is the work around or is there a plan to provide for this?
Many thanks, Patrick