AnsweredAssumed Answered

Create a Value List with Filtered Records?

Question asked by ezeitgeist on Oct 20, 2016
Latest reply on Oct 20, 2016 by mike_wallace_rcc

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.