Go to related record issue

[ezra]

I have a db with 2 related files. In file A, I have a portal. In the Portal row, if I assign a button the script step of going to the related record in file B using the 'Format' -> 'Button' -> 'Go to related record' from the menu, this works fine. However, if I assign the same button a script, even a script that has the identical step 'Go to related record', clicking the button does no do anything.

Thank you in advance.

[Lee Smith]

Hi ezra,

I'm not familiar with the nuances of v7, but If I'm understanding your question correctly, it would be the expected behavior in v6 and below too.

You stated that you put a button (I think) just on a layout in your Current File (File A), but it doesn't do anything. I'm not sure what you mean by that, but, if you are using the same relationship as the portal, it should take you to the related file (File :, and show all records that matched that relationship that were in the portal (i.e. the same records that you saw in the portal).

If it doesn't do this, then explain what does or doesn't do?

Lee

[ezra]

Lee, Thank you. I'll explain: In both cases, the button is in the portal. If the button is just assigned a 'simple' script step of going to the related record in the other file, it works. If the same button is assigned a script that I created using ScriptMaker, even if that script only has the same 'go to related record' step, the button, when pressed, does not take me to the related record - it appears as if the button does nothing.

[Lee Smith]

It should work the same, but you might have something in your script that is confusing FM. Not hard thing to do

Post your script steps as they appear, and I'll help you clean it up.

Lee

[ezra]

Lee- to debug, I reduced my script to a single step - 'go to related record' and it still does not work. As I mentioned, the identical step WORK when associated with the button through the Format > Button menu...Thanks again - Ezra

[Lee Smith]

Then maybe it has to something to do with your relationship.

Are you sure you selected the correct relationship, or even selected one Script Step (i.e. Edit the Script Step, select the script step, and then go to the bottom select the relationship).

Maybe you could post a striped down copy of your two files.

BTW, these are v7 files, so my advice can be wrong as I don't know v7 at all. and of course someone else will have to look at your files if posted.

Lee

[-Queue-]

This is proper behaviour for v3.

"In order to be consistent with other script steps and with previous versions of FileMaker Pro, the Go to Related Record script step no longer brings the related window to the front automatically, except when used from a button. In order to bring the related window to the front, you must add a Select Window step to the script."

[Lee Smith]

This is proper behaviour for v3.

It works in v6, I tested it before I posted.

[ezra]

Queue and Lee - Many thanks!

Indeed - adding the 'Select Window' step resolved the issue!

Best Regards,

Ezra