Variable value list flaky in Find Mode

[Renee B]

Hi-

I just can't seem to find a work around for this one...

Here's the scenerio: (running in Find mode)

I have a field called "field_search". This is a pulldown field, where the user decides which field they'd like to search. Search criteria is entered into a field called "search_criteria". What I need to happen is depending on what field is chosen in "field_search", the appropriate value list will appear in the "search_criteria" field.

What I have tried: (all running in find mode)

Enter data into "field_search". Click on "search_criteria" field, which executes a script that populates a global field called "pulldown" with 'set field' with data from "field_search". The script finishes by select/perform in the "search_criteria" field so that the pulldown info should appear. (Note: "search_criteria" is set as a pulldown with the value list from the calculation field "search_criteria copy".

Here is the calc for "search_criteria copy":

If(pulldown="winery",ValueListItems(Status(CurrentFileName),"Winery Name"),If(pulldown="City",ValueListItems(Status(CurrentFileName),"City"),""))

The value lists "Winery Name" and "City" created by referencing their respective fields (Winery Name looks to field "Winery Name" and City looks to field "City")

Here is what happens:

If I reimport the data, it works, but the more I play around with it, the value lists get combined (city and winery end up in the pulldown together.)

If I change the calculation or such, the pulldown will sometimes stop working altogether.

I'm really trying to understand why this is happening so I can figure out the appropriate work around.

Any ideas??

Thanks in advance!!