Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Go to related record issue

Featured Replies

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.

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

  • Author

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.

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

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

Lee cool.gif

  • Author

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

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 cool.gif

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."

This is proper behaviour for v3.

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

  • Author

Queue and Lee - Many thanks!

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

Best Regards,

Ezra

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.