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.

portal error: "invalid" table relationships

picnichouse
in Relationships

Featured Replies

Hi,

I'm getting an error in a very complex Fm database I'm working on. I am in TableA and there is a portal to TableB. There is a relationship from TableA to TableB via Field1. The relationship allows new records to be created in TableB from TableA. When I'm in a TableA layout trying to enter records into a portal to TableB, I get this error:

"This operation cannot be performed because one or more of the relationships between these tables are invalid."

Anyone know why I might be getting this error? It's making me crazy!

Thanks,

Andrew

I'll ask the obvious questions in case you have overlooked one of them.

1. Does the match field Field1 have a value in TableA?

2. Are you entering data into an empty row in the portal?

3. Is Field1 the only match field between the two tables?

4. Have you tried scripting part of the data entry to see if that works?

Possibly you are using an unstored calculation, a global or a related field as the match field in the target of the relationship.

FMP won't let you declare a relationship like this, but you could have modified the the target field since then.

Create an account or sign in to comment

https://fmforums.com/topic/36383-portal-error-invalid-table-relationships/
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.