Poor Find Results via Calculation

[jim shelton]

I have Customer::Agent as a text field and Job::Job Number as a number field (next serial number)

These fields have worked for years. Now we began to use the Agent field. So I created a new field, CompositeJobNumber.

Calcualtion: If (Customer::Agent = "AB Note" ; "AB" & Job Number ; Job Number)

It will not allow me to store, so finds take 5 minutes vs seconds.

I need a better result. Using FM10 with FM Server9 adv.

thanks

Jim

[IdealData]

If you cannot store the calculation then another way would be to hold the field as an auto-enter based on the calculation. However if any of the related elements change then the field won't update.

Overcome this with a nightly script run on the server to replace the field contents based on the calculation.