Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement