Is possible obtain with @PickList, 2 or more categories form a categorized view?

HCL Domino Domino Forum
1

I have two databases. A & B. I am pulling information from a view in A to a form in B. One of the views on A is categorized. Is it possible to obtain with @PickList, 2 or more categories form this categorized view? this is the code I am using

server := @Text(@Subset(@DbName;1));

value := @PickList([Custom]:[Single];server:“A.nsf”;“PO”;“Orders”;“Select a Order from the list:”;2);

FIELD YTDPurchaseOrderNum := @DbLookup(“Notes”:“NoCache”;server:“A.nsf”;“PO”;value;“PO”);

FIELD Vendor := @DbLookup(“Notes”:“NoCache”;server:“A.nsf”;“PO”;value;“Vendor”);

FIELD YTDDatePurchased := @Date(@DbLookup(“Notes”:“NoCache”;server:“A.nsf”;“PO”;value;“OrderDate”));

FIELD YTDTotalCost := @DbLookup(“Notes”:“NoCache”;server:“A.nsf”;“PO”;value;“Total”);

FIELD YTDComments := @DbLookup(“Notes”:“NoCache”;server:“A.nsf”;“PO”;value;“Description 1”);

@Command([ViewRefreshFields]);

@All

thanks in advance for your help

2

Subject: What you could do

Hi, Tom. What you could do is have a column in the view that you are using as your source for your @PickList that has multiple field values from the document concatenated together separated by some value i.e. like an asterisk. When you retrieve that column value with the @PickList, you can then parse the returned value with @Left, @Right, etc. to get each field value that you are trying to find. Using this coding scheme, you can avoid all those additional @DbLookup statements.