Employee Matching

[Guest]

Hello,

I have employees that can have up to three different expertise and orders
that can also have three different requirements. all requirements and
expertise are stored on individual fields eg if employee has 2 expertise, it
is stored as follows: -

employee id SkillId
1 1
1 2
2 1
2 2
2 3
same with the requirements

Order ID SkillId
1 1
1 2
1 3
2 1
2 2

in the above case only employee 2 can do order 1 but both employee 1 and 2
can carry out order 2

How can i find out which employee can do which order ? Please can some one
help ?

I have tried to put the two tables in the same query and matching the skill
id but this just retrieve many values, which are not correct.

 

[[MVP] S.Clark]

If you linked the two by Skill, I would expect to see the following Orders
matched to Employee 1:

1
1
2
2

So, to restrict the list to unique values, you can change the Unique Values
property of the query. Or try Group By.