Primary Key in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with employees. Some of the employees are trainers, some are trainees, some are neither. I was successful in writing two queries that separate the trainers and the trainees. I have another table with many 'subjects to be taught'. Yet another table (taught subjects) combines trainer, trainee, subject taught, date taught, comment. I can see where I can pull my trainee and trainer queries into the relationship board but I can't develop a one to many relationship from the querys to the taught subjects table. Suggestions

TI
Sam Beardsley
 
Yet another table (taught subjects) combines trainer, trainee, subject taught, date taught, comment. I can see where I can pull my trainee and trainer queries into the relationship board but I can't develop a one to many relationship from the querys to the taught subjects table.
Click to expand...

[Taught Subjects] should be joined to the Subjects table by Subject
Taught (of course); it should also be joined to TWO INSTANCES of the
People table - one joined by Trainer, the other by Trainee.

In your Query you should be able to link Trainer to the PersonID in
the trainers query, and Trainee to the PersonID in the students query.
 
Back
Top