JamieT Posted January 24, 2005 Share Posted January 24, 2005 I am sharing multiple related files on FM server advanced. This problem seems to coincide with my updating FileMaker 7 to version 3 but I was having similar problems on some user's computers before the update. Server Advanced is updated to version 2 but I believe the problem is not on the server end because the same thing happens when running the database from my local drive. Basically, when "Go to related record" is included in a script, alone or otherwise, it doesn't do anything (doesn't go to the external layout it's supposed to). When I make a button that does the same thing without actually writing a script, it works fine. Unfortunately, I need to run an if statement before committing the "go to related record" script step. I can't find any other post that relates a similar problem. Does anyone have any ideas? Thanks! Link to comment Share on other sites More sharing options...
CobaltSky Posted January 25, 2005 Share Posted January 25, 2005 Hi Jamie, The GTRR script command does still work in 7.0v3, so I'd hazard a guess that there is something amiss with the way you've specified the source TO or the target layout in the scripted version of the command. Either that or the script is altering the context prior to execution of the GTRR (changing the current record or the layout etc) such that the command executes in a different context than you were expecting. HTH Link to comment Share on other sites More sharing options...
JamieT Posted January 25, 2005 Author Share Posted January 25, 2005 I'm sure you are right; the answer is something simple, I just can't figure it out. I ran some more tests in response to your message to no avail. I've created new scripts with only the "go to related records" step and create a button that runs it and it doesn't do anything. I then assign that button directly to the "go to related records" function and it works fine. Some other interesting points: The "go to related records" script step does seem to be working with relationships to files other than the one I'm having trouble with. I created a new (duplicate) relationship with this file to check if the original relationship I'm using is corrupt but it doesn't work either. The "go to related record" script doesn't work in returning back to the original file either. The relationship is operational because I'm using it to display some fields in a portal and that is working fine. Any other ideas? Thanks! Link to comment Share on other sites More sharing options...
CobaltSky Posted January 25, 2005 Share Posted January 25, 2005 Well, if a scripted GTRR is working when pointed to other files, but not to this one file, I suggest that you start looking for anomalies with the target file. For example, are there several layouts with the same or similar names, but based on different TOs? ARe there several TOs with similar names? Do you have more than one copy of the file lying around? It seem likely that something is pointing to the wrong place or fouling the process up. Link to comment Share on other sites More sharing options...
JamieT Posted January 26, 2005 Author Share Posted January 26, 2005 OK, I'm afraid I was a little wrong in my earlier post. Go to related record does not work if placed in a script, period. It doesn't work with any other file or relationship; I've tried a number of other databases. The same function works fine when called directly, but that same function doesn't do anything if it's in a calculation. Weirdly enough, when I go the the file using other means, it opens on the layout and viewing the records that the "Go to related Records" calculation was supposed to call up. So the calculation is doing everything except bring up the right layout for the user to see. Any other ideas out there? I'm gettig desperate. Thanks. Link to comment Share on other sites More sharing options...
-Queue- Posted January 26, 2005 Share Posted January 26, 2005 Is this for FM 6 or 7? Your profile shows 6, but you referenced 7 in the original post. If it's in 6, you need to call a script in the related file to put you on the right layout and restore or maximize the window. If it's in 7, could you post a copy/clone of your problem file? Link to comment Share on other sites More sharing options...
JamieT Posted January 26, 2005 Author Share Posted January 26, 2005 Hmm.. I filled in 7 for the original post but you're right, I need to update my personal information. It's FM 7 Server Advanced. The Go to related record is supposed to send you to the layout you select in 7. Link to comment Share on other sites More sharing options...
-Queue- Posted January 26, 2005 Share Posted January 26, 2005 Yes, I know. That's why I requested you post a sample of your file, if using 7. Link to comment Share on other sites More sharing options...
JamieT Posted January 27, 2005 Author Share Posted January 27, 2005 I have attached two small files that relate to each other to demonstrate what does and doesn't work on my system. test_files.zip Link to comment Share on other sites More sharing options...
RalphL Posted January 27, 2005 Share Posted January 27, 2005 Make a new layout in file Department using the file Employee. Make your scripted GTRR go to the new layout. It works normally. Link to comment Share on other sites More sharing options...
JamieT Posted January 28, 2005 Author Share Posted January 28, 2005 OK, that seems to be working. I guess I will just have to avoid navigating to other files and do everything through one master file. I didn't even know you could set a layout to a table outside the file. Thanks for your help!!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7022 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