>Thanks, but I'm having a little trouble phrasing what I want. I believe you have answered that question. But I didn't explain what I want properly...
>Table one, is an item table and description. i.e. the two fields I'm using are itemkey, itemdesc
>Table 2 is a table listing grpitems, which stores a list of items in a group. where the itemkey in the grpitems table links to the item table.
>
>I have a group called Everyone. This is the group of items in the grpitems table that everyone can see.
>
>Let say that the group called lab is adding items that only the lab can see. (Items that are not in the everyone group.) To aid and reduce data errors, I would like to present to the data entry person who is adding items for the lab group, a list of items that do not include those selected for everyone. After all, they can already see them. So maybe the phrasing of my question is I want to present a list of items, not including those in the the everyone group. I basically want to filter out items that are in the everyone group from the list.
A subquery, for example
... where KeyField not in (select KeyField from OtherTable) still seems appropriate in this case.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
