populate list box with names 1

[lespaul]

I have a list box field on a form "Judge". I want the choices in the field to be generated by selecting all the people in the main address book (names.nsf) who have a title of "Judge". Any ideas on how to accomplish this?

thanks,

leslie

 

[Giaggio]

I made something similar using a notesdocumentcollection populated with the result of a search in the database, for all document in the collection I can then create an array with the values I need extracted from one or more fields per document and put the array in a multi value field hidden in the form or dialog box.
The formula for your list or combo must be simply the name of the hidden field.
I can create for you a demo .nsf if the above is not clear.
Hope will be helpful.
P.S. I'll work on your "fill array with items".

 

[pmonett]

Hi Leslie,

Another solution would be to create a view in the NAB, hidden, collecting all users who have the title "Judge", and do a lookup on that.
Of course, that implies that :
1) you can modify the design of the NAB
2) you must define the view as to not modify or refresh/replace design
3) you remember the view when you upgrade the Domino server

Other than that, the view shouldn't bother anything.