Creating Multiple Records From A Single Form Entry

[LeoDee]

I have a form which allows students to sign up for a class. If the student signs up for multiple classes I have to make separate entries for each class.

What I would like to do is allow the students to select multiple classes on a single form and generate a separate record for each class selected.

Any suggestions?

Thanks,

LeoDee

 

[pono1]

Leo,

If you haven't already created them, you'll need two tables: TblStudents, TblClasses. In TblClasses include a field of the same name and data type as the primary key in TblStudents (but don't make it a primary key in TblClasses). This field will allow Access to cross-reference students and classes. Once your tables are set up, search for "nested subforms" in the Access Help file and in these forums and then practice setting up a main and nested subform, two forms that act as one, supporting a many-to-one relationship between tables. Typically the nested subform is set to continuous form view while the main form is configured as a single form. This is a terrific feature -- nested subforms --- but it's not perfect. Expect to take some time to get the format just so, stretching this form edge or that form edge, turning off navigation buttons, setting titles and headers.

Regards,
Tim

 

[LeoDee]

I have a Student table, a CLasses table and am generating records for a Waiting List table. I had thought of having a form which captured the Student and all they Classes they wanted to take and writing a separate record for each Student/Class to the Waiting List table.

I will try the approach you recommended. Thanks.

 

[Pat Hartman]

You might want to take a look at this mult-select listbox example. It does a similar thing to create attendance records.

Multi-Select Listbox

 

[LeoDee]

Thanks for your input.

I found a way to make it work. It may not be the most efficient way but it does the job.

I enter the data into the form which is associated with the output table (Student/CLasses). I have the user click on a button which executes newrec. Then I move the data from the form fields to the table fields and execute SaveRecord.