Back to last database

[Jan K]

Has anybody a script for this?

I have a solution with 30 databases. One of them is the "HELP"-database, where i have all the help messages. In this database it would be nice to have a button that takes you back to the last database you left, before you went to the "HELP"-database.

Thank you very much in advance.

[ February 18, 2002, 04:17 AM: Message edited by: Jan K ]

[Steven H. Blackwell]

What operating system and what vrsion of FIleMaker Pro are you using?

Old Advance Man

[Jan K]

Dear Old Advance Man,

I am using Windows 98/2000/XP with FMPro 5.0

[ February 18, 2002, 07:57 AM: Message edited by: Jan K ]

[andygaunt]

You could add a global field PreviousDB (Text)to your help file that is populated when the user clicks the help button from whichever database.

Q. Do you have a constant relationship from each database to the help file ( 1-1 )

If yes you can use the setfield scriptstep from the calling database to

SetField PipeHelp::PreviousDB Status(CurrentFileName)

This will record the file that you were last in.

If not you will have to have a field in each DB that holds the current file name and copy that and paste into the help file.

As for getting back out, you could write a long IF script to check the value of the global field and go to that DB.

This is not dynamic in that each time you add a new file you will have to update the script.

Not sure if Old Man can come up with an easier solution, possibly something dynamic.

[danjacoby]

Just have the "Help" file ToggleWindow(maximize) when it opens. That way, it'll cover all the other windows. When you close it, the file you came from will still be in front.

I like simple solutions, I do.

[andygaunt]

Dan,

So simple, yet missed.

Was in the scripting mode when looking at this post and got carried away. Somehow missed the logical answer when writing. Been here for 10 hours straight now, with my mindset in calculations and relationships.

Oh well, maybe take a break and come back later. Let the brain chill for a while.

quote:

---

Originally posted by danjacoby:

Just have the "Help" file ToggleWindow(maximize) when it opens. That way, it'll cover all the other windows. When you close it, the file you came from will still be in front.

I like simple solutions, I do.

---

[Jan K]

Thank you very much for your clever solutions.

[Peter Fenner]

If your database is shared on a network and you close the file on the server then users won't be able to access this file.

I suggest using a close button that simply performs the script "Hide Window" - this way the database directly behind will always appear.