go to related record

[Robert Moran]

I am trying to make Go to related record work with two existing windows, Client List and Client Detail. The GTRR works without issue but the script prompt only offers a new window option to enable one to go from one window to another. In this case, I want to select an existing window (Client Detail) to go to via GTRR as I don't want to generate a ton of new windows to do something as simple going from one view of the same table to another. Is there any way to do this? TIA

Bob Moran

[David Jondreau]

In some ways, FileMaker is "windows" based. For example, a found set of a table in one window will persist while navigating to other layouts, but only within that windows.

You've got to add some scripting before your GTRR that closes open Client Detail windows before opening a new one.

[comment]

If you have the same found set in both windows, you can pass the record number to go to. Otherwise you'd need to perform a find in the Client Detail window - or, as David says, close the existing one and open a new one. In any case you cannot GTRR in another existing window. It's either the same window, or a brand new one.

[Robert Moran]

Unfortunately, it's not the same found set. Question,what scripting would be needed. This is something FM should allow to happen. Spawning new windows is just not the way to do something like this. Thanks for giving me some advice as I know enough about scripting to be dangerous, not good. :)

[comment]

Question,what scripting would be needed.

For which option?

BTW, have you considered using a single window with a portal showing a list of all (or some) clients alongside the details of the selected client?