AnsweredAssumed Answered

How do I set up a one field to find data from within 3 different fields?

Question asked by shrubr2 on May 31, 2012
Latest reply on May 31, 2012 by philmodjunk

Title

How do I set up a one field to find data from within 3 different fields?

Post

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 2

                            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?

FM_problem.jpg

Outcomes