AnsweredAssumed Answered

Search that can quickly add multiple existing data to one column to search

Question asked by yodavish on Oct 22, 2018
Latest reply on Oct 24, 2018 by philmodjunk

I'm trying to build a new search layout similar to this one below:


The circle part of the image is data that exist already within FileMaker under "Part Types". There are 1304 distinct types. I tried creating a list value but it's over the threshold for characters allowed.


The goal is:

     1. Open a search layout that allows for certain searches, one of which shows the multiple values for part types, but how I can make sure it's only the distinct rather than the millions of records?

     2. Add or Remove multiple distinct part types

     3. Search those all of those multiple searches as if it was doing a "New Request" Search for that one part type field.

Any guidance on this would be great!