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.

Field related problem

clippermedia
in Relationships

Featured Replies

I have 2 db, the master contains 2 fields named "client" and "page num." The other db contains "page num." and "client", ""client2", "client3", "client4". The fields named "client#" are pop-ups using the same value-list.

I want to get the master "page num." field to show me the page number based on the relationship between the master "client" and any of the fields "client#" in the second db.

Thank you

Use a multi-key. Make a text calculation that consists of a return-separated list of the 4 client fields. Then use this calculation as the key to the master database. If any of the 4 client fields match the master client field, then the relationship will work.

  • Author

It works! Thank you.

I was making the same without returns.

Create an account or sign in to comment

https://fmforums.com/topic/10424-field-related-problem/
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.