Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find records not in another table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01466852
Message ID:
01466864
Views:
34
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.

Does this help?
Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform