@PickList based on previous @PickList

HCL Domino Domino Forum
1

Hello all!I am trying to figure out how to get a dialog list of employees based on the company chosen.

I am working in a database connected to an existing address book (we call ‘the Rolodex’). In the existing address book I’ve created a view called “CompanyList” that is categorized, pulling from all records.

The first button in the NEW DB runs the following command:

FIELD CompanyName:=CompanyName;

@SetField( “CompanyName”; @PickList( [Custom] ; “<the db’s replicaID>”; “($CompanyList)” ; “Select a company” ; “Please select the Company from the Rolodex:” ; 1 ))

This populates the first field (CompanyName).

Now I want to create a second button or dialog list that searches the Rolodex for employees belonging to CompanyName.

Any ideas? It’s driving me nuts!

Thanks so much!

Todd

2

Subject: @PickList based on previous @PickList

If I understand you correctly, all you need is another @Picklist but include the last (optional) parameter of CategoryName using the value of CompanyName. Of course, you would need to have a view of employees that is categorized by CompanyName.

Hope that helps.

3

Subject: RE: @PickList based on previous @PickList

You were right! Thank you so much for clarifying that. I never used that last option. It works like a charm. Thank you!!!

4

Subject: @PickList based on previous @PickList

see the picklist documentation in Help, there is one more parameter for just what you want.