Global field perform a find?
It's me again... I am using FM 9 (shared over a network) on a MAC (OS X) and am having trouble with a particular script. I am a beginner to intermediate FM user, so the more detailed the replies ther better.
I have a layout that collects information in the following fields: Name, Date, AM Activity, PM Activity, LPM Activity. I want to perform a find that will find ONLY records that contain a particular number, regardless of whether the number (091044, for example) appears in one or all of the Activity fields -- as long as it appears in at least one of the fields, I want the record found. So, I set up a global field (labeled gSearch), and a button to run the following script:
Set Error capture [ On ]
Go to layout [ Original Layout ]
Enter Find Mode [ ]
Set Field [ ADMIN DATA::AM Activity ; gSearch ]
Set Field [ ADMIN DATA::PM Activity ; gSearch ]
Set Field [ ADMIN DATA::LPM Activity ; gSearch ]
Perform Find [ ]
If [ not Get ( FoundCount ) ]
Show custom message [ "No record found" ]
It's not working. It appears to perfom a find, but it finds ALL records, regardless of the number I asked it to find.