Kennel Posted April 8, 2004 Share Posted April 8, 2004 I wrote a script to go to a specific screen to conduct a find. If no records are found FMP takes the user back to the original layout but not to the record the user started from. A blank screen appears. Is there anything I can put in the script to have the user returned to the record from where they started? The user cannot altered the fields on the screen that they are viewing so the find function is stored in a button that takes the user to a screen where they can access all of the fields to key in search criteria. FileMaker Version: 6 Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
-Queue- Posted April 8, 2004 Share Posted April 8, 2004 Relate a global text field to the id field. Before performing a find, set this global with the current record id. If no records are found, Go to Related Record [show, gID_to_ID]. Link to comment Share on other sites More sharing options...
Kennel Posted April 9, 2004 Author Share Posted April 9, 2004 Fantastic fix. Works great. Thank you. FileMaker Version: 6 Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
GlennC Posted April 10, 2004 Share Posted April 10, 2004 Queue, I thought a global field couldn't be used in a relationship because it cant' be indexed. When I've tried something similar I got a warning error when defining the relationship. Also what is the 'Show' in the Go to related record calc? Link to comment Share on other sites More sharing options...
Lee Smith Posted April 10, 2004 Share Posted April 10, 2004 Hi Glenn, You can use a Global in the left side of a relationship (Current File), but not on the right side (Related File). Lee Link to comment Share on other sites More sharing options...
GlennC Posted April 11, 2004 Share Posted April 11, 2004 Very handy piece of knowledge, thanks Lee! Link to comment Share on other sites More sharing options...
-Queue- Posted April 12, 2004 Share Posted April 12, 2004 The 'Show' is for the 'Show only related' checkbox. FileMaker Version: 5 Platform: Windows 2000 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7318 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