Relationships: I just don't get it.
I've been trying to make a database to track events and employee scheduling at my theater. I just can't get things to work right. I don't know what I'm doing wrong. :(
Here's a small sample of what I'm trying to accomplish:
In table 1 ("Events") we enter information about the events that are going to be presented:
Event ID No.
In table 2 ("Employees") we enter the names of the employees who will be staffing these events.
Employee ID No.
In the third table (the join table) we are supposed to bring the events and employees together so we can schedule people to run the shows.
I have the part where the event links in to the join table working but I can not get the link between the join table and employees working.
What am I missing? I've been banging my head against this for two weeks. I just don't know what to do.