One field = multiple one-to-manys

[SaviorSix]

Hello again, quick normalization/relationship themed question:

picture of relationships is attached

I have a main table which lists study name/number, and several other tables which list study information (recruit method, recruit criteria, etc)

The study number is unique, there can be many methods and criteria for each study, therefore I have several one to many relationships from the same Study ID field. This is OK, correct? For some reason it seems wrong to have so many one to manys branching off from one table field....

 

[neileg]

Looks OK to me. Relationships exist in the data or they don't. All you do in Access is model the real world.