Basic Layout Question

[NewShoes]

Hey all,

I'd like to create a database that stores college courses and associated modules. I have the basic layout of a Courses table and a Modules table but here is the issue....I'd like to be able to create a predefined list of Modules that I can then "attach" to a particular Course. Similarly, I'd like to have the same functionalisty for Courses.

For example, I have Course "Business IT". I then would like to attach the modules "COMP101", "NETWORK102" etc to "Business IT".



I'm sue this is very basic but I just cant seem to get my head around it.

Thanks in advance for any help!
-NS

[orange]

There are some excellent tips here
http://www.rogersaccesslibrary.com/forum/topic238.html

And a related data model here
http://www.databaseanswers.org/data_...king/index.htm