After trying dozens of things and research all over the internet and asking on other forums I am having absolutely zero luck and am pulling my hair out with this problem. My DB has the following tables: Registrant info, Sessions, Periods, Classes. There are three sessions total, four periods in each section, and multiple classes in all. A registrant can sign up for a session and must have at least one class per period for whatever session they sign up for.
Here is what I need to do. After entering Registrant info into the form I want to select a session for that registrant (Session 1, Session 2, or Session 3). After selecting the correct session, I want a new area on the form to open in which I can select (probably with check boxes?) which period/classes within that session that Registrant is enrolled in.
I have unsuccessfully tried again and again to figure this out, but now I need help. Any ideas?
Here is my DB. As you can see, I have tried to use a command button to do the trick, but I'm having no luck.
View attachment 37339
Here is what I need to do. After entering Registrant info into the form I want to select a session for that registrant (Session 1, Session 2, or Session 3). After selecting the correct session, I want a new area on the form to open in which I can select (probably with check boxes?) which period/classes within that session that Registrant is enrolled in.
I have unsuccessfully tried again and again to figure this out, but now I need help. Any ideas?
Here is my DB. As you can see, I have tried to use a command button to do the trick, but I'm having no luck.
View attachment 37339
Last edited: