I am trying to create a dropdown (Value List) that only uses records from one table that have specific entries into a given field.
I have a Contacts Table. Each contact has a "Contact Type". I want to create a dropdown list of all the contacts in the table EXCEPT for one type. I was hoping there was a filtering aspect to the Value List, but no such luck.
Technically, I am using the dropdown list in the same table as the records, in a popover filling in a global field.
Is there anyway I can do this? I was thinking of maybe creating a 2nd occurrence of the table and doing something but wasn't sure how to limit to records.