nikster Posted August 23, 2009 Posted August 23, 2009 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
bcooney Posted August 23, 2009 Posted August 23, 2009 (edited) 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, 2009 by Guest
Recommended Posts
This topic is 5571 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now