Query Relationships Question

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

Guest

Hello,

I have a join table that makes a relationship between the "Employees" table
and the "Training" table. The tables are named:

1. Main
2. Employees
3. Training
4. EmployeesTrainingJoin

Included in the query are MainID (PK), EmployeesID (FK from Main) and
TrainingID (FK from Main). The other fields from Employees and Training are
also included in the query.

Q. Do I need to include fields from the join table inside the query.

-Simon
 
Hello,

I have a join table that makes a relationship between the "Employees" table
and the "Training" table. The tables are named:

1. Main
2. Employees
3. Training
4. EmployeesTrainingJoin

Included in the query are MainID (PK), EmployeesID (FK from Main) and
TrainingID (FK from Main). The other fields from Employees and Training are
also included in the query.

Q. Do I need to include fields from the join table inside the query.
Click to expand...

Depends on what you want to do with the query.


John W. Vinson[MVP]
 
Hi John,

Turns out I did need to include it because it contained fields relevant to
other tables. Had to play around with it some but got all the data to display.

Thanks for responding John

-Simon
 
Back
Top