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