G
Guest
I have a two tables linked together:
1. TaskTable
2. Assigned People Table
The task table has a one to many relationship with assigned people table.
The assigned table has engineers and responsible technical managers (RTMs).
Someone has requested that I show only the positions where a responsible
technical manager is not assigned. I created a query combining the two
tables. Here is an example of the results:
Position 1 Engineer 1
Position 1 Engineer 2
Position 1 RTM
Position 2 Engineer 1
Position 2 Engineer 2
If I query out the responsible technical managers, I still get the position
but with the engineers listed:
Position 1 Engineer 1
Position 1 Engineer 2
Position 2 Engineer 1
Position 2 Engineer 2
I should only see Position 2, since Position 1 does have an RTM.
How do I do this?
Thanks in advance.
1. TaskTable
2. Assigned People Table
The task table has a one to many relationship with assigned people table.
The assigned table has engineers and responsible technical managers (RTMs).
Someone has requested that I show only the positions where a responsible
technical manager is not assigned. I created a query combining the two
tables. Here is an example of the results:
Position 1 Engineer 1
Position 1 Engineer 2
Position 1 RTM
Position 2 Engineer 1
Position 2 Engineer 2
If I query out the responsible technical managers, I still get the position
but with the engineers listed:
Position 1 Engineer 1
Position 1 Engineer 2
Position 2 Engineer 1
Position 2 Engineer 2
I should only see Position 2, since Position 1 does have an RTM.
How do I do this?
Thanks in advance.