Limit a value list to one customer type
Hello -- I see there are a lot of threads about this, but none seem to help with what I am looking to do.
I am using filemaker's business template for invoicing that pulls down all company names to help make an invoice - but, I have way too many names in my contacts, so I want the value list to show only Contacts who are customer type Retail.
Can I make a field in the Contacts table that calculates "Company Names whose Customer Type is Retail" and then use it as the value list? What would that formula look like?
thanks for any help - Don