best way to create a matrix

T

tina

Hi
I have 2 unrelated tables one called employees one called work instructions
I would like to be able to create a matrix to show the emploees who have a
certain work instruction or which employee has which work instruction the 2
tables are linked from different databases and I will only be using employee
name from employee table and work instruction number and description from
work instruction table.
I think I need a yes/no field do I add this in a query if so how?
Can some one plese advise best way forward
Thank you
Pat/Tina
 
R

Rick B

Sounds like you need a third table. This is a many-to-many join. You would
need a table where you can enter the employee number, and the work
instruction number. This may have one entry for a particular person, or
more.

Then, you can include all three tables in your queries, reports, and forms
to get all the details.

This new table should only have two fields. One for the employee number,
and one for the key from the instruction table.
 
Top