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.

Invalid Table relationship

Spidey
in Relationships

Featured Replies

The attached files the replicate of the file I have problem with.  It works fine in the local computer when I search for product line name. However, in my server when I try to find product line name. It produces "...one or more of the relationships between these tables are invalid" Is it because of the files in the server?

fmdata2.zip

Works (apparently) correctly for me locally...

Couple of questions: Is the Server file actually also on the Server? And why is there a local table called Server in the fmdata file, AND a table called Server in the Server file - that's bound to cause confusion.

The table referenced in the graph is the external Server table in the Server file...

  • Author

Thank you for your reply.   Yes. Server file is in the fm server.  And don't worry the local server in product master.   It was for testing locally.

Try recreating the external data source on the files that are on the server - they're currently file:filename, and should probably be fmnet:...

Create an account or sign in to comment

https://fmforums.com/topic/98977-invalid-table-relationship/
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.