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.
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.
Where am I going wrong?