Find problem

[davepain]

I don't know if anyone can help, i have 6 fields with various data in them including a serial number (which sometimes contains text) I want to be able to have a global field that you enter a serial number to be found, then run a script to find this data in any of the six fields, i can not use an if(global = any of the others) type script as the 6 fields contain other information aswell.

Sorry about the laymans description!

[jasonwood]

Two ways...

ONE

make one calculated field "allFields" that contains the data from all six fields.

(= field1 & " " & field2 & " " & field3 & " " & field4 & " " & field5 & " " & field6)

Then perform the find on that field...

Enter find mode

Set field, allFields, myGlobal

Perform find

TWO

The other method would involve a little more scripting

Enter find mode

Set field, field1, myGlobal

New Record/Request

Set field, field 2, myGlobal

New Record/Request

Set field, field 3, myGlobal

New Record/Request

Set field, field 4, myGlobal

New Record/Request

Set field, field 5, myGlobal

New Record/Request

Set field, field 6, myGlobal

Perform Find

I think the second method might be slightly faster and more reliable since there's no calculation.

[jim lee]

What I use for 99% of my complicated finds is a calculation field that results in 0 or 1 Example: if field "X" = global field "Y".

Then the find is just look for a 1 on the calculation field.

For your case I'd do a calculation field that was set to 0 or 1 depending on wither any of the serial number fields were the same as the global. Then the find is just to look for a one on the calculation field.

This just seems a lot simpler than dealing with complex finds to me.

Hope this helps!

-jim lee