Basic One to Many Relationship Question

[Bkper087]

This seems pretty basic so I'm sure this question has been asked before, but I'm not really sure what to search for to find the answer. I have a master table with names, addresses, etc. I want to create a related table that will list things people are involved in (church, school, etc.). The way I had in mind to design it for simplicity sake was to create the second table with four columns like this:



Pk - fkID - OrganizationID - Role/TitleID

The organization and role would be look up fields based on separate look up tables. The problem I have is when I go to the query with both tables included it will not let me edit the secondary table fields because they currently do not all contain a related ID. Not every person master table will have related information in the secondary table and in many cases when they do they will have multiple entires. My thought was that I would simply type in the fkID and be fine, but it doesn't seem to be okay with that.

How then can I create this type of relationship?

[Bkper087]

Nevermind. I figured out that I needed to create a Junction query with each and then one overall between the two. It's been a long day.

[Bkper087]

Well I take that back. Still doesn't let me edit the fields

[orange]

Here's a free video from TrainSignal re junction Tables and Many to Many