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.

Pop up Value list needs to show in concatenated field

chiggins68
in Value Lists

Featured Replies

  • The table, "Address" has a field "Location".
  • The Location field is formatted as a popup menu using a value list "Locations_VL" "Checked with "Override data formatting with value list"
  • The value list "Locations_VL" is pulling from a table called "All_Locations" with a "Primary Key" field and a Location Field. the table is populated with separate locations
  • The Value list "Locations_VL" is using the "Primary Key" as the first first field and the "Location" field for the second with the "Show values only from second field".

This works fine the issue is when I want to concatenate fields into a field "Main Address" I enter the Location field and I get the Primary Key instead of the Location from the Locations_VL table. I understand why its doing this but I'm not sure how to get it to show the Location field when in the "Main Address" field

Edited by chiggins68

Do you have a relationship between Address and All_Locations, based on matching: 

Address::Location = All_Locations::Primary Key

If so, use the All_Locations::Location field for your concatenating calculation.

 

Create an account or sign in to comment

https://fmforums.com/topic/107836-pop-up-value-list-needs-to-show-in-concatenated-field/
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.