Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Gerard
I assume in your example of a Select * "Area" is a field in the table you want to filter. This situation uses a "tag" table that contains the ID's of records in the table I want to include. The strategy allows the user to create a "Group" Table containing a Group Description (such as "North Dublin", "West Dublin", etc. for example). Then the user can have records "Join" one (or more) groups. It does this by creating a record in the "Tag" table. This table contains records that have the Group description and the record ID of a record that is a member of that Group.
What needs to happen is to have the "Select *" read the "Tag" table for "North Dublin" (as an example) and for every hit on the Tag Table create a cursor (or view) record using the cooresponding record ID.
Hope this explains this strategy.
All help appreciated.
Bill Wright
Précédent
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