View based on @dbcolumn Multiple value list in form
Posted on 2004-08-07
I know that embedded views can not be generated by dynamic selection criteria and that the "single category" option (which I use for other things) will not populate, of course, based on more than one value in the form. But I am using @dbcolumn lookups to populate a multiple value list. The list is of documents the user chooses as "related" to the current document. For example, an interview form with a multiple value @dbcolumn lookup field that allows the user to select related People documents corresponding to the people in the interview...(people are a collection documents in a lookup view selected by "People" form).
I should like to be able to have a view or other method on form that allows me to click and open the "related documents" based on the values (between 0 and n) listed in the "related documents" field. In the above example, after the user selects the People in the Interview, the embedded view displays all documents containing any of the selected People values in the appropriate field: e.g., "NameField contains any values in list."
Knowing that embedded views don't do the trick, am trying to think of another way to approach the goal: allow user to select multiple documents, view that list, and click on any item in that list to go to the document referred by the item in the list.