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.

one field with multiple values

grumbachr
in Calculation Engine (Define Fields)

Featured Replies

many to many to many... (argh!) ? in my database i need to be able to assign multiple values to one field.

its a situation where one person can be assigned multiple devices.

and one device can be assigned to multiple people. i currently have a users database with a device id and a user database with a user id and both have proper relationships to link old records together.

the trouble comes in when i am creating new device records and assigning them to a user. i guess i could make multiple device id fields for each user but the number varies from user to user. some might need 1 some might need 5. and having a bunch of extra fields makes things messy.

i hope I've explained that well enough if not I'll try to answer any questions to have you understand it better.

Do a search for +join +table +relationship on this site. There are many previous threads on the subject of many-to-many dbs.

Create an account or sign in to comment

https://fmforums.com/topic/26428-one-field-with-multiple-values/
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.