AnsweredAssumed Answered

Limit a value list to one customer type

Question asked by donok on May 16, 2014
Latest reply on May 16, 2014 by philmodjunk


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