Ok my goal is to create a database with this purpose: I am a member of an Honors program and want to keep a roster table accurate. I also want to create a table or form or something that I can document each meeting with a date...and document the topics discussed/and notes about the topic. I made a table for each meeting, with 3 columns (Topic, Minutes, Notes). I made the roster. Is there a way that I can tie in the roster to each meeting, so I can use check marks for each person on the roster whether they showed up for that meeting? Basically each meeting would pull first and last name info from the roster and allow me to keep track of rosters for every meeting.
With this, I could also set up forms to show which meetings people went to etc... is this possible? And how can I do it?