AnsweredAssumed Answered

How do emulate the FileMaker search box

Question asked by g4guitar on Dec 5, 2015
Latest reply on Dec 11, 2015 by BruceRobertson

I know I am probably missing the obvious here so apologies in advance.


I have a table called 'Contacts' and a Layout called 'Contacts' I have a search box set up so I can type in lets say the name Steve and it finds anyone with Steve in their name. The script I use looks for names in the c_FullName' field that contain 'Steve in the field. The script is as follows.


Screen Shot 2015-12-05 at 6.37.15 PM.png


My problem


I have a layout called 'Class' with 7 different fields called Student1, Student2, Student3, etc. The setup is basically identical to the above except for one thing. The student fields ( Student1, Student2, Student3, etc.) are via a value list sourced from the Contacts table so even though I see the name of the student what the search sees is the Id number of the student fields. This means when I look for a name in the search box no names can are found because only the ID number is searchable. I know a work around for search for just one name e.g. one person called 'Steve' but I want all the Steves to appear.


When I use the the FM search box it works perfectly. In other words it somehow recognises the text in student fields.

Screen Shot 2015-12-05 at 6.50.05 PM.png


Where am I going wrong?