Refresh and dblookup (Mark II)

HCL Domino Domino Forum
1

Doh…Sorry.

I have a form that has 2 combobox fields, Area and Sub-Area. The user chooses an Area from a list and is then presented with a Sub-Area list. This is achieved through a dblookup on a view where each document is for an Area and contains the list of Sub-Areas for the Area.

This works fine when creating new documents, but not for amending existing ones.

When I change the Area, the Sub-Area list does not change. I have got the Refresh Fields on Keyword Change Set, and my dblookup specefies NoCache.

I have tried putting in LotusScript on the On Exiting event of Area to use theRefresh (and Reload) methods but I can’t get it to refresh the list - I have always been confused by the Back and Front end documents and how to think of them together.

Any pointers would be grategully received.

Many Thanks…

Pete

I have tried everything I can think of

2

Subject: Refresh and dblookup (Mark II)

Have you set “Refresh field on keyword change” for the field Area? That should be all you need to do.

3

Subject: RE: Refresh and dblookup (Mark II)

Hi

You need “Refresh fields on keyword change” on teh first field, and “Refresh values on document refresh” on the second field

HTH

Kiers