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