I am creating a DB for a nursing home where members are offered a list of courses they'd like to participate in. Each member is given a form with their name and a list of courses, and they check off the courses they'd like to join. I have a table for members, a table for courses, and a table for member_course. I'd like to duplicate the paper form in Access so staff can go through the paper forms, and check off the courses that a member would like to join on the Access form so that member_course_T gets populated, and then be able to view the data by course name with the names of members who chose it (and then have them confirm attendance, etc. but that's the next step...) In short, I'd like a form that shows one member and a list of all courses with a checkbox next to each. When the checkbox is clicked, a record with memberID and courseID should be added to member_course_T. Many thanks for your time and assistance!
Aucun commentaire:
Enregistrer un commentaire