My problem is I need to filter the data displayed in a DBlookup without
using a table for the filtering.
A database table with several fields, 2 called "KeyWord", "TableName". In a
particular entry the keyword field may be = to "Maintenance Type", and the
field TableName = "Planned Work" however scattered throughout the table
would be various entrees with the "KeyWord" Maintenance type and Table name
= to whatever.
Normally I would use a table filtered for the KeyWord = "Maintenance Type"
then the Lookup pointing to the filtered table and only the values with
TableNames with Keyword = Maint..Type displayed in the lookup.
The trouble with the above approach is a table is needed for every different
Keyword in the Table and in this particular table there are about 40! Is
there a way to filter by only using the Lookup.