I put a @dblookup formula to load values in a dialog list from a variable setted in an hidden field that I set with a @picklist.
When I set the value the first time all works correct. If I change the variable in the hidden field, @dblookup still load the values based on the first variable.
Hope is all clear.
Thank you.
Subject: Have you checked “Refresh choices on document refresh”?
If the choices are loaded from a field of which the value changes depending on another field,
set “Automatically refresh fields” on the form.
Set “Refresh fields on keyword change” on the field delivering the keywords.
“Refresh choices on document refresh” will then update the choices.
Subject: yes already setted
Form properties was already setted on “automatically refresh fields” and the field already to “refresh fields on keyword change” and “Refresh choices on document refresh”, too.
I explain better the process, maybe I made a mistake:
field1 (input text)
field2 (dialog list) / (refresh fields and refresh choices setted)
The user choose a value in a picklist, that set a value in field1.
The field2 trough the @dblookup load the values from a view in the dialog list based on field1 value.
All is correct and it works, but if user reopen the picklist and choose another value, the @dblookup still load in field2 the same items of previous field1 value.
The process is correct?
Subject: use ReCache or NoCache
use ReCache or NoCache in the @DbLookup formula
Subject: I add
Nocache already setted.
I add @PostedCommand([FileSave] ) at the end of picklist command and it works.