Do you have the following relationships?
Events::Event ID No = Jointable::Event ID No
Employees::Employee ID No = Jointable::Employee ID No
Everytime you want to assign an employee to an event, you'll need to create a new record in the join table with the correct matching envent and employee numbers. This can easily be done with a portal based on the Join table.
Okay... So I think I get it.
The tables were pretty much right and the relationships were right. It was the way I was looking at them that was creating the problem.
I was in the join table trying to look at both of the other tables when I needed to be in the "Event" table, looking at the "Employee" table THROUGH the join table.
I made this analogy to somebody else who didn't understand but I'll try it out on you guys.
You are standing in a hallway, looking at a dozen fishtanks on shelves all along the walls. Each fish tank can have any number of fish.
Hallways are "Events". Fishtanks are records in the join table. Fish are "Employees."
If I make my layout using the join table, it is like I am sitting in the fish tank so I can not join fish and events because I can not see into another fish tank.
If I make my layout using the "Events" table and making a PORTAL to the join table, I will be able to look at ALL the fish tanks and put fish into any tank I want. When you do it the other way, you can not get to any of the other fish tanks. You must be standing in the hallway to sort fish into fish tanks.
I don't think your analogy is correct. A fish can be only in one tank, but an employee can participate in many events, thus have many records in the join table.
Let me suggest a simpler one: events are events, employees are employees, and records in the join table are tickets.
You're right. That was out there in left field.
Anyhow, I think I got it now.
Now! To take this and apply it to the big database! ;)