How do I set up a one field to find data from within 3 different fields?
I am trying to recreate an existing SalesAid using Filemaker and I am having some creative problems.
It appears there is 1 data entry field (I'll call it SearchTerm) but when you enter data 3 possibilities exist for the data displayed.
enter PlantCode = R280 and I get what I expect - a portal showing the various sizes of that plant and related values.
enter a portion of the Field BotanicalName and a want to show a summary list output and I want it to appear with a
vertical scroll bar so I contain the display to say 19 lines
for instance Azalea 1 I want to select from the list and show related data on a different layout that looks like #1
Azalea 3 etc.
enter a unique SKU and show the related data for that one item.
Is my SearchTerm a find or a entry field? Is my SearchTerm a seperate Table or Part of the Data Table?