I have problem with the dialog list. I have 2 views and 2 dialog lists. First view is list of main categories, second view is list of subcategories.
I need this: When i choose main category in first dialog list i need show only subcategories for selected category in second dialog list.
For example:
In first view i have column “make” and rows are: Ford, Volkswagen, Seat,…
In second view i have columns “make”, “model” and rows are: (Ford, Escort), (Ford, Mondeo), (Ford, Scorpio), (Seat, Toledo), (Seat, Leon)
When i choose “Ford” in first dialog list, i need show only Escort, Mondeo, Scorpio in second dialog list.
You can use one form with 2 fields: Make and Models. Make is a single value text field where you input the make of the car (Ford, Volkswagen). Models is a multi-value field with all of the Models for a given Make. So your first document your create with this Form has this data.
Make: Ford
Models: Escort, Escape, Mustang …
You then create one view that filters on this Form that is 2 columns:
Make (sorted ascending)
Models
You then have another form with your dialog lists:
Make - which does a lookup to the first column of the view above (and the list is set to “Refesh fields on keyword change”)
and
Models - which does a lookup to the second column above (and the list is set to “Refresh choices on document refresh”)
Take a look at @dbcolumn and @dblookup in online help. That’s all you get for free
Subject: Because views are NOT refreshed on ‘refresh fields on keyword change’
If you absolutely must have the pick from a view, rather than from a CFD field, then you need to add a few lines of lotusscript in either the exit of the first field or the entry of the second that gets the view and refreshes it’s index
I would suggest it should be in the exit of the first, as this give the server a few microseconds longer to get it’s act together
But i still have small problem with refreshing. When I choose “Ford” in first dialog list, i have “Escort”, “Mondeo”, “Scorpio” choices in the second dialog list.
It’s OK. But when I now choose other make (VW for example) in first dialog list, i still have Ford models in second dialog list.
Options “Refresh fields on keyword change” at first dialog list and “Refresh choices on document refresh” at second dialog list are checked.
Mark Taylor: I’m very sorry but i found only one topic with similar problem and answers have not resolved my problem. Now, Bob’s answer helped me.
EDIT: Aha. If i use Formula and @DbColumn for choices in Make dialog list, it’s refreshing. If i use view for choices in Make dialog list, the Model dialog list is not refreshing when i choose other make. Why?
