try using == in found set , as i know == matches the whole field.
In your script, you should have something like this:
Make the fields for Layout 2 global fields and do not enter find mode until after they enter their criteria. That way, you can manipulate the criteria as needed in your find requests.
Go TO Layout [//select layout 3 here]
Enter Find Mode
Set Field [Layout3Table::Location ; "==" & Layout2Table::GlobalLocationField ]
Set Error Capture [on]
I haven't tried the following, but this script may work if you want to keep things the way they are and not use global fields. This script step assumes that you have already entered "Perth" in the location field while in find mode.
Set Field [YourTable::Location ; "==" & YourTable::Location ]
Try it out and see if it works or not.
Thanks for the suggestions Phil.
I have tried the second option that you suggested but this did not solve my problem. Using this method i get no records returned. the only way that i can get the results that i am searching for is to go to Layout 3 and then manually enter ==Perth, then perform find.
If i was to use your first suggestion with the global field how would i do this - do i need to have this set up seperately?
Hmm, ran my own test and that second script should work. The script does successfully insert == in front of the text the user entered while in find mode anyway. I posted just a fragment of the total script here. You'd still need to perform the find after this step.
To use a global field, you would place your global field on a layout, enter "perth" into and then perform the script. You can trigger the script with a button or a script trigger on the field.
Thanks Phil - got it working. Looks like i was using the wrong filed to use as the look up!