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.

Conditional value list in FM 5.5

Featured Replies

I want to make the value list used in one field to be dependent on the

value of another field in the record.

For example,

Country = "United States"

State/Province value list = "Alabama, Arkansas, etc"

or

Country = "Canada"

State/Province value list = "Alberta, British Columbia, etc"

How do I set this up?

1- create a file (country_state),

2- define 2 text fields as "country" and "state",

You will use this file as countries and states table.

3- create a file "master",

4- define the fields you need specially "Country" and State "fields",

5- in the master file, File>>Relationships>>New>>

6- Name the relationship as "states"

7- select "country_state" as target table,

8- select on the left fields menu "Country" field,

9- select on the right fields menu "Country"

We can define 2 value lists

10- in the master file, File>>Value List>> New

11- name it as "Country"

12- use values from field:

13- Select "country_state" file,

14- select country field,

15- OK, OK, Done,

16- New (Value list)

17- use values from field,

18- Only related values

19- select "states" relationship,

20- select "state" field,

21- OK, OK, Done

22- in the master file, go to layout mode,

23- "country" field>> right click>> Field Format>> Popup List >> select "Country" value list

24- "State" field>> State value list

25- Go to browse mode,

26- select at the country a country,

27- then select realtional values from state value list,

28- lastly, thank me smile.gif

  • Author

Thank you for your input. I will give it a try.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

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.