relating a table back to PK

[Miethr]

I am fiddling with a DB right now just to try to work out some table relationships. I have a PK, Name, it is accompanied by a year in school. I then want to relate the year in school in a different table with the requirements for that year.

such as

Year Requirement1 requirement2 requirement 3

these would be check boxes (yes/no), and I could accomplish it in this format, but I am trying to have a normalized DB so
I realize it should be like this

1st year requirement
1st year requirement
1st year requirement

but I do not know how to link this back to the PK name when switching it to this format, so that I can pull up a form that shows if the person has completed the requirements for the year they are in. I am I going about this wrong? I have been looking at normalizing DBs and relationships but can't figure out the logic for my DB thought.

Thanks for any help


Riley

 

[cuttsy]

I am struggling to follow your discription. If you post the table structure of these 2 tables I may be able to give you some help.