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.
Juggernaut

how can I make a list of values from a field?

The Dog
in Calculation Engine (Define Fields)

Featured Replies

Hi All.

Have a little problem and would love some help.

I have a FM6 database that contains a field holding a number. Several records can have the same number in the field. After doing a search on some other fields I might end up with 10-50 records found.

What I would like to do is to get the numbers. But only one even if it is found in more than one record. The numbers I would like to make into a valuelist (that changes after a new search).

Any help would be great

The Dog

Edited by Guest

If you want to make value list that contains the values in a field, then all you have to do is,

Define value list

Click on Use Values from field

click specify field

select Use values from first field, find the filed you want

click include all values

Then your done

Dave

  • Author

Thanks for the speedy reply.

But I tried this and it returns the numbers for all the records in the base. Not for just the found records. And this is what I need...

Dr. Virus

Create an account or sign in to comment

https://fmforums.com/topic/48258-how-can-i-make-a-list-of-values-from-a-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.