I work for a property/hospitality company, which has decided to elect me to design their Intranet. I am presently building a db in Domino R5 that is going to manage our extremely large file system.
I am stuck on one aspect and hoping you can help.
I am using a ComboBox, in a form, that is dynamic, it uses at DBColumn to populate itself. This ComboBox is setup to "Allow values not in list". I would like this ComboBox to create a view using a template for each unique value put in the ComboBox. I have tried using @CreateView but am not having much luck. I have tried doing this by embedding a view into a form and using radio buttons. But, the embedded view loses the sort options for each column.
I have been attempting to solve this problem for some time now and really feel that I have hit a brick wall. Could you please help me?
The best solution is to have a view that is categorized by values in the ComboBox. Embed the view in your page and then choose the "Show Single Category" event in the Programmer's pane. Set the event to a formula that gets the current value in the combobox. This will then show only the documents that relate to the value in the combo box.
For further information see the following:
Single Category View in the developer forum.
This was first published in February 2002