Using a query to regroup and present data

[DatabaseWoes]

Hi...this is probably a noob question...



Here's a query sorted two different ways. The first is sorted by employee: http://imgur.com/IJNpQd6
The second is sorted by staffing position: http://imgur.com/jC7CPoS

As you can see, one employee may be matched to several different staffing positions, and any staffing position may be match to several employees.

Here's the question: Is it possible to write a query or queries to present the data with one-to-one matches? In other words, given a set of, say, five employees and five positions, can we have the query results show Employee #1 matched to Position #1, Employee #2 matched to Position #2, and so on?

Thanks.

[ranman256]

but what if Employee #1 matched to Position #1
AND
Employee #2 matched to Position #1

who gets preference?

[DatabaseWoes]

Hi...it doesn't matter. All five positions, even though they have different position numbers, are identical. I just need to establish this kind of management so the update query doesn't to try to put everyone in the same position.