I've created a layout titled Searchfields, which shows records from my master file

The fields I have placed on this layout are:

First Name

Last Name

Phone 1

Phone 2

City

State

I've created the following fields in my DB file

_search_value is a global text field (to be used in the next step after I get this dropdown to work)

_search_list is a Calculation, Indexed field FieldNames ( Get ( FileName ) ; "Searchfields" )

_search_field is a global text field

I've created a value list search_names using values from the -search_list field referenced above.

When I add the _search_field to ANY layout (the layout is based on the same table as the _search_list field), when I click on the arrow for the dropdown box..I get a ?

I am trying to emulate the action on the attached file.

Thanks.

SearchFilter.zip

I'm not sure exactly what you want but I adjusted your file by how I would create this functionality. Note a few differences ... on the global values field, I changed it to upon field exit instead of OnObjectModify. And I set it to fire the script on that field upon hitting enter to also make it easier so they won't have the dumb carriage return and instead it will fire if they expect standard functionality of hitting enter.

See if this gets you closer. :^)

Also note the script parameter attached to the triggers.

SearchFilterREV.zip

Edited September 27, 201213 yr by LaRetta