How do you referense multiple subjects for example??

[DMcManus]

Hi,

Here's what I have.
I have a list of resources. Each of these fall into at least one subject
(Art, Biology, Chemistry, etc) Many of these have only 1 subject, however
all the others have multiple subjects.

What I want to do is have one table that lists all of the subjects.
And another table that is the Resource Table and it has a Subject Field
(which would be tied to the Subjects Table) But I don't know how to do
this since some of the Resources have multiple subjects. It seems like a
pretty common thing to happen I just don't know how to go about fixing
this. Someone told me to just make Yes/No fields for all of my subjects.
But I have over 40 and for multiple reasons I don't want to have to resort
to that kind of workaround.
Can anyone help me out here?
It seems like I should be able to do
this and I've looked everywhere to find an answer but have come up blank.

Thanks in advance.
--Dan

[preeti]

Hi,

Have one table for your subjects (which you are have). This is your master subject table. Then have one table for your resources (if there is a master list). This is your Master Resource Table. Then make another table subject/resource which has one field linked to your subject table, and another field linked to your resource table. The primary key would be these two fields. You are creating a one to many relationship between your resources and subjects.

Hope this helps,

Preeti

[DMcManus]

Great, thanks, I knew it had to be something simple. I had come from it from a different angle and didn't even spot that it was just a classic one to many relationship...d'oh. (:
Thanks much