Examiner Database Design Suggestions

[seth1685]

I am trying to create a database that will contain three tables



Examiners
Programmes
Modules

I need to be able to assign multiple programmes and modules to individual examiners

Each Examiner will be a unique record

Modules and Programmes can be assigned to multiple Examiners, although not at the same time

The main problem that I am having, is what is the best way for me to store a list of modules and programmes for each examiner?

I was originally going to use the combo box that allows you to select multiple records, however, there are hundreds of modules and this would be a slog to scroll through.

Any suggestions?

If this is vague or lacking in detail, my apologies.

Thanks!

[orange]

Have you tried to create a data model?

see http://www.rogersaccesslibrary.com/T...lationship.zip