A client has asked me to add some functionality to a database I wrote a few years back in FM6. They want to be able, from any line in a report, to go to the corresponding (related) record for that report. Then from that related record, go back to the report using s "back" button.

When the master record exists in the same file, this is not a problem. I simply added a script step to write the Layout number to a field I created called NAVTem before it goes to the master record layout.

The problem is, most of the master records are in another related file. So, in every database I write, I create a file called "defaults" where I store various data. (i.e. tax rates, etc) So, I created a 2 fields in this file called "NAVFilename" and "NavLayoutNumber". So when the user clicks on a related record, before it goes to the related record, it, writes the current filename and layout number to these 2 fields. This works from every file. So now the database has a clear navigation back to the report. Then the plan was, from the related files, the user would click a back button to get back to the reports. So I created a script that would simply look at the "defaults" file and navigate to that file and to that layout number. But I've gone up and down the scripting tree and can't see where or how to do this.

More specifically, how to I open or navigate to a file using a field value as the filename? If I can navigate to the file, then I can get to the layout via the "Go To Layout" step. But I cannot figure out how to get to the file specifically using the value in that "NAVFilename" field in the "defaults" module.

I thank anyone in advance who can help me on this one.

Nick Paonessa

Check this out: SeedCode Back Magic

and this:

Ray Cologon's Back button technique file

However, FM is not a web browser, and I would discourage trying to design an interface that mimics a browser.

Edited August 23, 200916 yr by Guest