conditional value list not updating

[Miko]

this is all being done in fm 8 advanced, despite what the profile says.

i have a file with a conditional value list. it is working fine, however, i have set the layout to auto save and still when i exit the field that the condition is based on which is the client field, the matter field will not show the correct matters until i click out of all the fields, sometimes it takes several clicks outside the field.

the way the condition works is this: there is a calculation field that automatically names a record based on the type of client entered. if it equals that in a matter database, then those corresponding matters show up in a matter field on the main table. this auto updated without a problem in fm 6. is this a bug? is there a work around? or am i doing something wrong?

thanks in advance,

Limore

[Kip]

Maybe you have put indexing on in your calculation field? Than the new "matters" will not automatically appear because it first needs to relookup the entered value. Maybe you can choose not to store the calc. results.

Edited October 10, 2005 by Guest

[Miko]

thanks. actually i just looked at the calculation and the calc was referencing a customer id field in another table. i set it to reference the customer id field from the existing table where the calc lives and all is fine. duh?

thanks,

Limore