Hi all,

I'm having a bit of a problem here with getting data into the correct DataBase. I have two DataBase Files open and I'm using the script below which states to use this DataBase "weather.fp5" but for some reason if the second DataBase is the front most window it tries to use that one.

Any thoughts or work arounds?

tell application "FileMaker"

activate

try

activate database "Macintosh HD:Users:dalejmartin:Desktop:weather.fp5"

on error

open "Macintosh HD:Users:dalejmartin:Desktop:weather.fp5"

end try

set theRecord to create new record

try

Thanks,

Dale

Edited March 24, 200619 yr by Guest

I'm using Filemaker Developer 7.

This works for me with multiple databases open

tell application "FileMaker Developer"

tell document "YourDatabaseFileNameHere"

tell layout "YourReferencedLayoutNameHere"

set therecord to create new record

end tell

end tell

end tell

Edited March 24, 200619 yr by Guest

Thanks for the reply.

But can anyone confirms this for FileMake 6? I tried what was suggested above but it still doesn't work

Thanks,

Dale

Hi all,

I'm having a bit of a problem here with getting data into the correct DataBase. I have two DataBase Files open and I'm using the script below which states to use this DataBase "weather.fp5" but for some reason if the second DataBase is the front most window it tries to use that one.

No workarounds required, but you do need to write your script properly. There is no "activate database" command. You need to use "go to window". If the correct file is not open you can use open database to open the file.

tell application "FileMaker"

activate

try

go to window "weather.fp5"

on error

open "Macintosh HD:Users:dalejmartin:Desktop:weather.fp5"

end try

set theRecord to create new record

Edited April 1, 200619 yr by Guest