Excluding data from a multi-table query

D

Dennis

I have a task as follows:

- User provides a SSN in a form
- Value is passed to a query that looks up multi-records in Table1 based on
that SSN
- One of the columns in Table1 is TeamID
- Lookup all records in Table2 whose TeamIDs are NOT in Table1 for that SSN

So if I have the following values in Table2 for TeamID: 1,2,3,4,5

and the following values in Table1 for TeamID (multiple records mind you): 3,5

My final result will be data from Table2 for TeamIDs 1,2,4

For some reason, I am unable to make this happen. Any ideas? I'd sure
appreciate it!

Thanks!
 
D

Dennis

Well, it *almost* does what I need to do. I need to look at the exclusion
table by SSN. So IF for SSN 111-22-3333, there is a TeamID of "3" on file, I
do NOT want to show TeamID 3 in the drop-down (since it's already assigned to
that SSN).
 
Top