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.

Relationship not existing

simoncpage
in Relationships

Featured Replies

I have a relationship of files that are related and clicking in between relationships that exist is fine. However if the relationship doesnt exist how can I flag this up and ask the user if they want to create a new related record or add this number to an existing one?

Thanks

Simon

Use IsEmpty(rel::serial) to test for non-existence.

Q, my first guess would have been IsValid(). Is IsEmpty() better?

J

Yes. On another list we discussed this. Jimmy Jones of FileMaker Inc. stated that IsEmpty is optimized for this use. IsValid, although it appears to work fine, was never intended to be used for this purpose.

Really? What is the intended purpose of IsValid, then? It seems like that would be its ONLY purpose!

confused.gif

From FM 5.5 Help:

Description

IsValid returns 0 when:

Wow... i've been using IsValid for the wrong purpose for several years now! Huh. Thanks, guys!

I've always used Count ( relationship::remotekey ) though I can see how it may be slow if there are a lot of related records.

I used to use relationship::constant. It would be much faster than Count, but apparently IsEmpty is allegedly even faster.

Create an account or sign in to comment

https://fmforums.com/topic/23768-relationship-not-existing/
Go to topic listing

Important Information

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

I accept

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.