Title
Opening another file and performing a find request
Post
This should be easy and I'm probably making it harder than it should be, but I can't get FM to open another file and perform a simple find. Here is the script. It would be easier if I could copy from the script to here, but, alas, I can't.
------- while in the file the script is in, I touch a button to perform this script
Copy [select; Annual::Customer Number]
Open File [Customer data base]
Enter Find Mode []
Go to Field [Select/perform; Customer Data Base:: Customer Number]
Paste [Select; [Customer Data Base:: Customer Number]
Pause/Resume Script [indefinitely]
-------- I can't get it to open the find mode in Customer data base and paste the contents.
Create a script in Customer Database like this:
Go to Layout "Customer Data Base" (Customer Data Base ) ]
Enter Find Mode []
Set FIeld [Customer Data Base::Customer Number ; Get ( ScriptParameter ) ]
Pause/Resume Script [indefinitely]
Let's say you name that script "Find Records".
Then modify your original script to be:
Perform Script ["Find Records" from file: Customer Data base ; Parameter: Annual::Customer Number ]
I am assuming that the file has the same name as your table. If not the text in blue will need to be changed to that of the file name. These scripts also leave any data previously copied to the clipboard intact--which will make your users happier with your database when data they may have copied doesn't disappear every time they run your find script.