Refreshing items in a uidoc where used in a view

HCL Domino Domino Forum
1

When creating a document there are 2 dialogue lists. 1 is the unique values in a 2 column table ( item 1 in the view of the table). A 2nd dialogue list uses the value selected in the 1st one to present all the values 2nd column. As followsFormula 1 ( populates field MainSec )

view := “(VTBL)”;

@DbColumn(“”; “”; view ; 1)

Formula 2

key := MainSec;

view := “keyword”;

@DbLookup(“”;“”;view;key;2)

This actually works ok.

But if you go back and change the value in MainSec ( Formula 1 ) the drop down in Formula 2 is the same as the first time MainSec was populated.

If I save the document and reopen it Formula 2 works ok.

This has got to be a uidoc vs backend doc thing.

Any suggestions?

2

Subject: you need to have it refresh the form

On MainSec there should be a property of “Refresh values on keyword change”. Check this and it should refresh the second list.

3

Subject: refresh item in button

thanks charles. i had just done as you suggested and it almost worked.

now it puts the new choices in the second drop-down , when you change the value of the first drop-down, BUT it also includes the value you picked the first go around.