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.

Multiple Relationships Issue

Reynaldo
in Relationships

Featured Replies

  • Newbies

Hello Everyone,

I'm new to FM Pro 10 and I'm trying to create a proper relational database.

My problem is that in the KeyData Table, I can pull up the room, but I can’t pull up the Suite. It should work like this:

key_db.png

KeyData [RoomID] -> Rooms[suiteID] -> Suites[suite] and that path should return the Suite Name in the KeyData table, but so far its only returning blanks for suites. I think I've read that FM Pro has problems grabbing field values from chained tables, is this true? and if so is there a work around? Thanks for any input.

Can you post the calculation?

It sure looks right. I would look at the data in the Suite ID, on one that you think should match.

Create an account or sign in to comment

https://fmforums.com/topic/71120-multiple-relationships-issue/
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.