Is there a way of doing this

[The Big Bear]

Hi all

I have a steel material db that has 1000 or so records. The program is used at different locations by one user at a time. I was wonder if anyone knows of a way of having the users pick the material they would use from the database and only that material will to be shown in a value list. I have seem this done in other programs where you would pick the data you want to display in a value by placing a check marked in a field and that data is present in a value list. When you deselect that item, the item is not longer shown in the value list. Can this be done in FM.

I know how to format a conditional value list but I not sure if this is a conditional value list.

Hope this make sense.

Thanks

Lionel

[Vaughan]

Create an "active" field in the materials table, a text field. ON the layout display it as a checkbox to enter "active" when selected.

In the materials table, create a calculation field "Materials Active":

if ( not isempty( active ) ; material type )

where "material type" is the field that contains the value you want to display.

Now make a value list based on the Materials Active field. It will display only those records that have something in the Active field.

[The Big Bear]

Vaughan

Thanks a bunch

Lionel