scripting between db's

[sboard0599]

I am trying to write a script that will get a job number in one db and find info about that job in another db. Basically, I find the job in question, copy the job number in the number field, activate the other db, go into find mode, paste the copied job number from the original db into the job field in this db and then perform the find. The script works when I run it as a standalone Applescript, but when I embed the script into a script I made in FileMaker in the orignal db it stops working as soon as my other file is activated. Any help out there?

[Chuck]

There's a better way to go about this, and you don't need AppleScript.

If there isn't a relationship between the two databases based on the job number create one. Then use the Go to Related Record [ Show, Your_Relationship ]. This will create a found set of records in the related database where each record has a job number that is the same as your original record. Then you can use the Perform Script [ External ] step to go to a list layout in the related database.

Chuck

[sboard0599]

I got it to work by telling the applescript to do scripts in each of the db's.

Phish_URL_Repo_new.zip

Phish_URL_Repo_new.zip

Phish_URL_Repo_new.zip