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!