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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Finding related records -- Really puzzled

November 27, 200520 yr

Hello,

I was wondering if someone could help me out with something that might be very elementary.

I have a database of teachers each with unique IDs which I regularly delete and repopulate from data on our server.

There are a couple of flags that I place on my end on FMP which I want to store on a related file with the IDs as the matching field.

I pretty sure I've set up the relationship properly because I can click on the checkboxes on the main file and the related checkbox in the related file checks on.

But, when I try to find records with the related checkbox checked "on" on the main file, I get a message telling me that "one or more of the relationships are invalid."

What could this be?

Thank you in advance for your help.

Hiroshi

PS I posted this earlier in the relationships forum, but perhaps it was off topic there.