@dblookup

HCL Domino Domino Forum
1

I’m having trouble with probably a simple answer. Can I do a lookup on 2 fields? The first column in the view is the client, the second is the level. I need to find the rate for the specific client and level

I started with this:

@If(ClientCode != “” & Employee = “Level I”; @DbLookup(“”; ClientRatesReplicaID; “(Rate Lookup)”; ClientCode; 3); “130”)

But it gives me the Server error: entry not found in index. Can anybody help?

thanks

2

Subject: @dblookup

Thanks…i figured it out using a combination of @dbcolumn and @dblookup and a couple of different views…

Thanks!

3

Subject: @dblookup

In LotusScript, this would be easy, using GetDocumentByKey method and passing an array for the key. If you must use @DbLookup, consider building a new “lookup view” based on the current view you are using but combine the client and level columns into one “compound” key column so that the new first column formula is:

client + level

For readability, you can also insert a special character between them like:

client + “~” + level

Then when doing your @DbLookup, build the same key using the same format.

Hope that helps.