Multiple Entries on one form

[SerenUK]

Hello,

Here is some brief background to my question, I am designing a system so that students can choose up to 6 modules with some constraints.

My design has 3 tables, Module Table, Student Table and an Options Table.
The Options Table has 2 fields which are ModuleID and StudentID (The primary keys from the other 2 tables).

I want to have it so that when a user is selecting their options they can do it all from 1 form and the data goes into the Options Table. How would I go about creating (Up to) 6 entries into the Options Table from 1 form?

Thanks for your time.

 

[CEH]

First, sounds like you are joining two tables on the "Options" table. You need one more field ... something like "OptionsID".
Then simply build a query from your tables needed, then build a form using that query as your source.

 

[SerenUK]

Thanks for clearing up the database structure.

Could you give me and example of the code that creates a new entry in the Options Table where I choose a Module(This will happen a minimum of 4 times and a maximum of 6 times on the same form).

What I don't want to have happen is the user having to use multiple forms to select each module but have it all happen on a master form. I will most likely use Option Groups as the input unless you have a better suggestion.

 

[CEH]

Well, if I am understanding this correctly..... "Modules" are maybe something like classes? ...... I would have a main form... with student information and OptionID. Then a subform for modules. The form and subform would be related on the OptionID field. Thus you could have many module entries for each "OptionID" record.