How to use Junction Table to populate DB

[Sorbz62]

Hi guys,

I'm still getting used to Access and am in the process of writing a Student/ Course one.

I have a table for Students, who can do many courses and one for courses which can have many students on them, ie many to many. So I have a junction table with the PK from each 2 tables as FK. Am I correct so far?

Now ..... Without code (coz I am clueless with how to do that) I want just 1 form which I can enter data on with student details and courses they have done on it - maybe tabbed with student details on the main form and each course on a separate tab. Is this possible?

Each course is carried out many times per year, meaning that I want to be able to add student details and then add new dates for courses or use existing ones, inotherwords have a combo box with existing data I can use but also add new data. Is that possible?

Thanks in advance!
Jim

[June7]

Simplest way is a form bound to the juntion table with two multi-column comboboxes. Choose student from one combobox, choose course from other combobox. And then a textbox for entering date. Check this tutorial http://datapigtechnologies.com/flash...combobox3.html

There are other tutorials at that site you may find of interest http://datapigtechnologies.com/AccessMain.htm

If you want to show more student info then use a form/subform arrangement. Main form bound to student table, subform bound to the junction table. Master/Child link properties of the subform container control will synchronize the related records.

The tab control as you describe would not be appropriate.