Keywords (dialog lists) - How to populate one list based on another?

HCL Domino Domino Forum
1

I have two dialog list fields. One has 3 values to pick from (no multiples). I want the second field to present different selections based on the first field’s choice.

I’m using keywords and @if in the formula for the second field, but I don’t really think that that is the problem.

Here is the @if formula code anyway:

@If(@Contains(Field1;“choiceA”);

@DbLookup(“” : “No Cache”;Keyword_ID; “V_Keywords”; “choiceA Elements”; “Contents”);@Contains(Field1;“choiceB”);

@DbLookup(“” : “No Cache”;Keyword_ID; “V_Keywords”; “choiceB Elements”; “Contents”);@DbLookup(“” : “No Cache”;Keyword_ID; “V_Keywords”; “choiceC Elements”; “Contents”))

The fields have to be close together on the form with and no saving will take place between picking the picking the first field and then going to the second field.

It works the first time I pick something from field 1, however, if I change the value, the field 2 lists do not change. I have tried refreshing the document upon exiting the first field and that also does not seem to do the trick.

2

Subject: Keywords (dialog lists) - How to populate one list based on another??

check the field properties (second tab in the field’s properties box)

for the first dialog list, the property ‘Refresh Fields on keyword change’ should be selected.

for the second dialog list, the property ‘Refresh keywords on document refresh’ should be selected.

As I work in a dutch version of Designer, it’s very possible that the english translation of these properties is different of what I typed above.

3

Subject: Keywords (dialog lists) - How to populate one list based on another??

Have you got the “Refresh choices on document refresh” and “Refresh Doucment on keyword change” checkboxes ticked on your fields (second tab of the field properties)?

4

Subject: RE: Keywords (dialog lists) - How to populate one list based on another??

I did not have ‘Refresh choices on document refresh’ checked. Thank you very much!