Open other database via script

[mikafm]

Hi folks,

I'm modifying a customer's application in FMP 4.0 and am stuck on an idea that just doesn't seem to fly.

Basically I start the application by clicking on file1.fm3, on one of it's forms there is a button that calls script1 to open file2.fm3, when file2.fm3 gets closed I would like script1(file1.fm3) to do a re-lookup based on a particular field and can't seem to get it to fly...

I tried this in script1(file1.fm3)

1 - open file2.fm3

(file2.fm3 auto runs a script to display one of it's forms

that has a close-file button on it)

2 - go to a layout

3 - re-lookup, no dialog, a field

Step 1 works but the layout does not get focus, without 2

and 3 the layout does get focus

Any help would be appreciated

[Steve T.]

Hi, Marc! I haven't used scripts much, but I think I have had db's open other db's and continue with their scripts okay. All I can recommend is that you try to track the scripts as the execute to see where the problem is. Add various simple script commands at various locations in the scripts and see if they all execute correctly. Maybe specifically introduce things like ENTER BROWSE MODE and stuff, too, even if they seem to be unnecessary.

If I get a chance later and you are still stuck, I'll see if I can simulate that in FMP4 at home.

--ST