Adding multiple lookup records to a form (not sure this is worded correctly)

[mert]

Attached is a draft database and a couple of slides providing a description the project and the desired data entry form. Most of the form is already created in Access, but I am struggling with showing all the Qualifications on a single page so they can be seen together as the user considers to which the Evidences should be mapped. How do I show all the Qualifications on a single form. I'm an Access newbie and self-teaching myself to this point, so I may have something structured incorrectly, but wouldn't know it unless the error came up and introduced itself to me. Thanks.
Team Qual Analysis.zip

[June7]

You want cascading (dependent) comboboxes. Review http://www.datapigtechnologies.com/f...combobox2.html

A form can enter records for only one table.

Is this a homework assignment? Was this form design specified by the assignment? It is not properly constructed for data entry purpose for the data structure.

[mert]

Thanks for the link. This is something I'm trying to create for work, so I'm free to modify as needed. The form is what I see as the best way for data entry. The data structure can be modified as well, and from your comment it appears that I should do so. How would you recommend I restructure? Should I have multiple subforms?

[June7]

I gather the core purpose of this db is to associate qualifications with evidence, hence the establishment of junction table QualEvidence. A junction table is used for a many-to-many relationship. Options for data entry are:

1. one form bound to QualEvidence and comboboxes to select evidence and qualification

2. form bound to Evidence and subform bound to QualEvidence with combobox to select qualification

3. form bound to Qualification and subform bound to QualEvidence with combobox to select evidence

Will need independent forms for data entry to other tables.

Maybe you will find this site helpful http://www.rogersaccesslibrary.com/

[mert]

Thanks, sir. That is quite helpful. I'll take a crack at that approach and let you know how it goes. It probably won't happen until next week, so stand by. Thanks again for your time and assistance.