I started off designing part of my form where I would select a grade level (Elementary, Jr, or Sr). Then the first combo box would show the Courses listed under that grade level. When I select the Course, the next combo box shows the Modules that are listed under that Course along with the price. That works fine now, but I have totally confused myself with the rest of the form.
I want to be able to design a form where you type in the Date of the transaction, SchoolName, StudentName, then you select the level (Elementary, Jr, or Sr), then select the Course, Module, then you put in a Quantity, and a P.O. number. My question is how can I put these all on a form when the Course and the Modules are made up of a query, and the rest are off of different tables. Do I have to use a subform? If I do, how can I connect the query to the other tables?
The tables I have are: Entries (EntryNum, Date, SchoolName, StudentName, ModuleName, Quantity, and PO); Students (StudentName); School (SchoolNum, SchoolName, SchJuris); then the Courses, and Modules tables.
I’ve made the following relationships: Many-to-Many for ModuleName from the Sample Modules table and the Entries table; Many-to-Many for StudentName from the Students table and the Entries table; and Many-to-Many for SchoolName from the School table and the Entries table.
I have just totally confused myself. I have a really hard time when there is a query involved. Let me know if you need any more info.