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 (Show Only Related) Questions

  •
sdpetemc
in Relationships

Featured Replies

I am upgrading an exising DB to FM 7.03 from FM 6. I have found that some of my Go to Related Reocord (Show only related records) no longer work. In FM 6 if no related files were present I would have a found count of zero in the related file. In FM 7.03 (mac) I am finding that if the relationship does not have any related records, it is returning all records! I have checked to make sure the match fields are both indexed and of the same field type... any sugguestions?

This is a change in the behavior of Go to Related Records[]. You should now test for the presence of related records before the Go to Related Records[] step.

If [ isempty(Relationship::RecordsID) ]

#No related records

Else

Go to Related Records [ Show only related records; Relationship ]

...

End If

  • Author

Thanks, that works great.

I added a 'not' to read better for me...

if ( not IsEmpty ( Relationship::One ))

Go to Related (show only related)

do script stuff

end if

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.