Filter a lookup table

Filter a lookup table


I have created a LookupValue table that contains variables that would be accessed by several other tables.  A sample of the LookupValue table is shown below:

Lookup Type     Lookup Value
Agency Type      Health PHO
Agency Type      Commercial
Agency Type      Misc
Gender              Male
Gender              Female
Salutation         Mr.
Salutation         Mrs.
Salutation         Ms.


I would then put a zoho lookup field in a table that needed to access the values, and filter the value displayed by the lookup type.  For instance, I would add a lookup field in a contacts table that would filter the lookup type to Salutation, which would only show the salutation lookup values.  This has proven very helpful in the past by creating more efficiencies in administration of data.  (e.g. Add one value to the lookupValue table rather than adding the same value to multiple tables.

The problem I am having is with Zoho views; specifically the filtering aspect.  Any reference in a view that accessed the lookupValue table shows every single value in the filter criteria rather than the ONE Value I would require.

Is there any way to restrict the criteria in the filtering of a view?

Thanks,


Leo Saumure