@dblookup using two keywords

[philip2000]

Hi,
can i use dblookup using two keywords? for example:
value := @DbLookup("":"NoCache";"":"Names.nsf" ; "People" ; "Mighty" and "Young" ; "FullName" @If(@IsError(value); "Not Available"; value)

when i use one keyword, it works fine but when i try two or more, it fails.

Thanks

 

[ABOzIT]

You can only define on key for the @DBLookup formula.

You can always do this another way if the two keywords are in the same document that you are looking for. Just create a view that has the value of the first sorted column as:

key1+key2

Your column would contain "MightyYoung"

This will join the two keys together and you would specify the joined keys as your "one" key in the @DBLookup formula to lookup the column of your new view

@DbLookup("":"NoCache";"":"Names.nsf" ; "People" ; "MightyYoung" ; "FullName&quot

If you are trying to return two documents you won't be able to do it via @DBLookup and you would need to do something in LotusScript.

Hope this helps