DB Look up...... fed up

HCL Domino Domino Forum
1

Folks!..

I have tried a lot to retrive data from document using Db Lookup, but i am failing to retriving…

Here is my requirement:

1st form : 3 feilds : “name of the company”

                          "location"

                          "phone no"

In above form i will add Name, loction & Phone no of the Company & i will create view for the same…

Ex:

Company name : XYZ

Loction : ABC

Phone No: 123

Now in 2nd form : 3 feilds : “name of the company”

                                     "location"

                                     "phone no"

I have created Dailog list for “name of the company” using Db Column(used view to retrive data)

If i select “Comapny name” in 2nd form, automatically “Location” & “Phone no” should appear.

For above i used below formula

@DbLookup(“”:“NoCache”; “”; “View”; “Key”; column no);

But i getting following error

“Feild location: Entry not found in index or view’s index not build”

Please help me in this regard, & i want know “What is Key word”

In above example which is key word???

Thanks

Vijay

2

Subject: DB Look up… fed up…

are you using the name of field storing company name ask the key. The field name should not be in quotations in formula

3

Subject: DB Look up… fed up…

What is the name of the column you want to retrieve? Have a look at the last tab of the column-properties?

Is this column sorted?

4

Subject: RE: DB Look up… fed up…

I want to retrive “Location” as well as “phone number” on selection of Company Name.

No, column are not sorted.

5

Subject: RE: DB Look up… fed up…

As far as I know, the first column in the lookup view has to be sorted for the key You want to use - thios goes for @DbColumn als well as for @DbLookup…

Try building the view with the first column being sorted and containing the Company name, 2nd column containing the location (no sort), 3rd column containing the telepone nr.