I have a value list that is based on a calculation field. My problem is I cannot get the calculation result showing on the value list instantly. Instead, the user has to click on outside of the filed to complete the record in order to get the calculation result appeared on the list. I noticed the reason of causing this delay is that the value list turns the calculation field with index on even I've set it off in the beginning. Can anyone get me some tips to resolve this problem?

Example: FY is a calculation field;

V_FY is a value list based on FY

The problem is V_FY doesn't show any the value until the user completed the record.

Create a non-calculation field and use Evaluate with your function enfolded within. Then base your value list on the new field.

Thanks for the response. Is Evaluate function only available in FMP 7? I am using 6.

In order to be used as a value list, a field must be indexed. New items are not added to the value list until you commit (exit) a record. So you will have to click outside the fields or press Enter on the numeric keypad to trigger the udpate.

Thanks. Good to know this is an irresolvable FMP problem, so I don