AnsweredAssumed Answered

Relationships:  I just don't get it.

Question asked by RandyS on Aug 7, 2009
Latest reply on Aug 7, 2009 by RandyS

Title

Relationships:  I just don't get it.

Post

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:

 

http://plato.mercyhurst.edu/pac/Practice400.fp7.zip

 

In table 1 ("Events") we enter information about the events that are going to be presented:

    Event ID No.

    Title

    Description

 

In table 2 ("Employees") we enter the names of the employees who will be staffing these events.

    Employee ID No.

    Name

    Position

 

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.

Any help?

 

T.I.A.  

 

Randy S. 

Outcomes