Jump to content

popup menu data source - how to add conditions


This topic is 2033 days old. Please don't post here. Open a new topic instead.

Recommended Posts

HI all,

 

I have a table called "locations". That table has an (int) ID (string) Location Name and (int) valid.

 

I am using that table as the basis for a couple of popup menu "values from" lists. I can't see anywhere in FM the option to create a custom value list.

 

What I need to do is for one of the popup menus, only include values where the valid field = 1. in SQL terms it would be select * from locations where valid = 1.

 

Other popup lists on there will need all of the rows, regardless of their valid setting.

 

As far as I can see, there is only the ability to include ALL rows of a table or a custom list of hard-typed values.

 

Many thanks

Link to post
Share on other sites

What I need to do is for one of the popup menus, only include values where the valid field = 1. 

 

Another option:

 

In your Locations table, create a calculation called cValidID, (result is number) with:

If ( Valid ; ID )

Then create a new value list called Valid Locations.  Based the first field on this calculation cValidID instead of the original ID field.  Select the location name in the second field to display.

 

Edited ... make the ID the same data type as your primary ID which I see is number.

Edited by LaRetta
Link to post
Share on other sites

This topic is 2033 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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