Problem in displaying data

HCL Domino Domino Forum
1

Hi,

I have a Data like below in view vwInfo

Company_Name Dept ManagerID

XXXX Fins 1000

XXXX Prod 1001

XXXX Qaty 1002

XXXX Gals 1003

YYYY Pins 2000

YYYY FrId 2001

YYYY QTty 2002

YYYY Bals 2003

Step 1:

I am populating Company_Name dialog box using the following formula

@Unique(@DbLookup(“”;“ProdServer”:“Information.nsf”; “vwInfo”; Company_Name ;1)))

Step 2:

Based on the Company Name I am populating Department in a Dialog box using the following formula

@DbLookup(“”;“ProdServer”:“Information.nsf”; “vwInfo”; Company_Name ;2))

Step 3:

Now i need to populate Manager Name in a Text box for which i am using the following formula

@DbLookup(“”;“ProdServer”:“Information.nsf”; “vwInfo”; Company_Name ;3))

In Step 1 Assume that i am selecting Company_Name as “XXXX” So that Dialog list Department will display only the depts in Company “XXXX”. It is Working fine.

In Step 2 Assume that i am selecting Dept as “Fins” So that Text box ManagerID will display only the Manager ID in Dept as “Fins”. But it is Displaying all the ManagerID related to COmpany “XXXX”.

I tried following formula also, but it didnt work

@DbLookup(“”;“ProdServer”:“Information.nsf”; “vwInfo”; Company_Name + ManagerID ;3))

Please help to solve this…

Thanks in advance.

2

Subject: Problem in displaying data

You concatenation of the two key-values will result in a single key, that is not available in the documents of your view.

This is precisely my suggestion. Add a hidden field on your documents, that will be filled (at document close) with a calculated key, based on the two fields. You could add a special character as speration.

Now you can build your search key from the 2 fields including the separation character.