Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find records not in another table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01466852
Message ID:
01466864
Vues:
35
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform