Greetings,
I create a field with type text and calculated for display. This field has a dblookup formula which takes value from another database on the same server.
My problem is this calculated field is not showing the current field value. I need to change the document to edit mode, refresh the screen and save the document in order to make the field updated. Is it a normal behavior or I miss a few steps here? FYI, I have enabled the option ‘Automatically refresh fields’ for the forms.
Regards
Subject: Calculated for display field not showing the current value
A couple of things I would check straight away…Does your dblookup have “NoCache” on? You would need that to ensure it looks up each time.
I had wondered if this field was once not a computed for display, in which case it will be stored and would need to be recalculated but it sounds like this is a new field?
Dbcache sounds like your best bet then…
Subject: RE: Calculated for display field not showing the current value
Thank you for your reply.Yes, NoCache is on.