DBLookup cache problem

HCL Domino Domino Forum
1

Hi All,

I have a field named “d”, a dialoglist with formula : @Unique(@DbLookup( “”: “Nocache” ; “” : “” ; “STF” ; Tower ; 2;[FailSilent] )), where “Tower” is an other field.

I have an other field - dialoglist too - with formula : @Unique(@DbLookup( “”: “Nocache” ; “” : “” ; “StockSearch” ; d; 2;[FailSilent] )).

First time when I try to use everiting is OK. But if I change the first field (“d”), and I would like to change the second field, than I get the same values as earlier.

Can anybody help me how to solve this? I tried to use the “Refresh fields on keyword change” option, but it doesn’t help.

2

Subject: DBLookup cache problem

In the 1st field, check the option “Refresh fields on keyword change” (like you already have)

In the 2nd field, check the option “Refresh choices on document refresh”

3

Subject: RE: DBLookup cache problem

Hi Rene,

Thanks for your help. It is working.

Attila