popup menu data source - how to add conditions

[bruceiow]

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

[Mark Scott]

Hi Bruce,

 

See if this FileMaker Help page answers your question.  Scroll down to "6. Choose whether to display all the values in the field or only related values."

 

hth,

 

Mark

[LaRetta]

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 January 12, 2015 by LaRetta

[bruceiow]

LaRetta - That has hit the nail on the head. Thank you :-)