I have a document that has a field which uses a dblookup from a view. The view is sorted. If I add/delete an item, the view shows the correct information. The problem occurs with the document that uses the dblookup. The document shows the data but it does not update the information when I change the lookup value.
For example the view says 1, 2, 3, 4
I have another form that uses the view for lookup. A field in the document uses the lookup and shows 1, 2, 3, 4. Which is fine. But if i edit the view and change to 1, 3, 4, the document using the lookup still displays 1, 2, 3, 4. These are forms that were already created, new forms show 1,3, 4.
I have NoCache and the field is computed.
a:= @DbLookup( “” : “NoCache” ; @DbName ;“Delegate”;“Service Delivery Review”;3);
@If(@IsError(a);“”;a)