Hi all

I have a flat db that we track our steel material with and would like to do a find on the grade and description fields. I have a calculated field that combineds the two fields together.

calc1 = grade&" "&descritipon , both fields are formatted as text

made another layout and enter three fields on it.

g_grade is a gobal text field

g_description is a gobal text field

calc2 is a calculated field that combined the two above

calc2= g_grade&" "&g_description

information for the fields "grade and descrition" are enter through a value list. This list is also attached to the fields "g_grade and g_description". i wrote a script and attached to a button for the find as:

Go to layout (input) original layout

Enter Find Mode

Insert Calculated Results[calc1,calc2]

Perform find

this produces an message that says there is no such animal.

When the calc1 field is filled in manual and the find is perform, you get the proper results.

i have been wrestling with this for a couple days and cannot seem to find where i have gone wrong. any help with be greatly appreciated.

Thanks in advance

Lionel

Try:

Insert Calculated Result [select,

Also, make sure that you have unchecked the "restore" option in both the Enter Find mode step and the Perform Find step.

If you continue to have problems, Put a pause script step immediately before the Perform Find step, so that you can see exactly what find criteria your script has entered before the find is performed.

Thanks Lee and Bob

Got it to work