Query Relationships Question

[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

 

[John Vinson]

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.

Depends on what you want to do with the query.


John W. Vinson[MVP]

 

[Guest]

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