Can a lookup be used in a find request
I am trying to identify if the contents of a NAME FIELD is a business and I have a list of a couple thousand key words. Other than just creating a find with multiple request, does anyone know if you can either:
1. create a lookup table where if name field contains any of the key words it will be found or
2. create the find in Excell or a text editor and paste or import into a find
i.e If NAME FIELD contains:
=" Industries" OR
=" INSTRUMENTATION" OR
=" INTERNATIONAL" OR
=" landscaping" OR
If you are using Filemaker 11, you might try using a portal with a portal filter expression.
Take a look at the two portals at the bottom of this demo file: http://www.4shared.com/file/plr_jbkk/EnhancedValueSelection.html
The left portal lists records that match by starting letters. The right portal matches using a "contains this text" type of method.