G
Guest
I have a table of job requirements that I assign to employees through a
look-up table. The requirement numbers are unique and so I have it set so
that neither the requirements nor the employee table allows duplicates. What
I want to do is make a query of the requirements table as linked to the
employee table (there is a subdatasheet that shows whether the req number has
been assigned) so that the query result shows only the unfilled requirements.
I will then be able to do my look-up on the query and then I will only see
the unfilled reqs in my dropdown. It seems like it should be a simple
solution, but I just can't seem to figure it out. Thanks.
look-up table. The requirement numbers are unique and so I have it set so
that neither the requirements nor the employee table allows duplicates. What
I want to do is make a query of the requirements table as linked to the
employee table (there is a subdatasheet that shows whether the req number has
been assigned) so that the query result shows only the unfilled requirements.
I will then be able to do my look-up on the query and then I will only see
the unfilled reqs in my dropdown. It seems like it should be a simple
solution, but I just can't seem to figure it out. Thanks.