DBLOOKUP not refreshing correctly despite 'NoCache'

HCL Domino Domino Forum
1

I have a form with a number of Dialog List Fields.

Field2 contains a DBLOOKUP formula for the choices and is using the result of another Dialog List (Field1) to find the list of choices.

So Field2 gets it’s choices using

@DbLookup(“”:“NoCache”;RELPLICAID;“VIEWNAME”;Field1;2)

The problem is that if I select a new value for Field1. I don’t see a revised list in Field2.

The workaround I have found is to choose Field1 a second time. The list for Field2 is then ‘magically’ refreshed.

There must be something obvious here but I can’t see it.

Any Ideas?

2

Subject: RE: DBLOOKUP not refreshing correctly despite ‘NoCache’

I think your problem does not have to do with @DbLookup; it has to do with when formulas are calculated on your form.

Do you have field1 set to refresh form on field change?

3

Subject: and Field2 to Refresh choices on document refresh.