Instead of finding a static value in a field, I need to find a value that is stored in another field.

For examle:

FieldA has the value "2004"

A line in my script is Find, restoring find request

.....I want one of those find requests to include finding in FiledB the value stored in FieldA, not the value "2004"

When next year comes along, the user will not have to edit the script to change the year, but would just have to change the value in FieldA

Thanks for your help.

-Jordan

Hi, Jordan. Your best bet may be to create FieldC, a calc field equal to:

FieldA = FieldB

Now, when the contents of FieldA and FieldB match, the value of FieldC will be 1 (the numeric value). If your script does a find for FieldC = 1, this should work.

HTH.

Jerry

Don't restore the request. Instead

Enter Find Mode [ ]

Set Field [FieldB, FieldA]

Perform Find [ ]