Is there anyway that you can have more than one key for a @DBLookup? If so how would do this?
Subject: @DBLookup
Christy
Can you give an example of what you are looking to do?
Thanks!
Chris
Subject: RE: @DBLookup
Please look at your email.
Subject: @DBLookup
Whenever I need to do something like that I create a new view where the first column is a formula that computes to the combied key I need.
For instance, if you needed to find the document(s) by CustomerNumber and PartNumber build your view with the first column formula as CustomerNumber + PartNumber (I usually put a “~” between the values, but it’s unnecessary)
.
Then in your lookup you also concatenate those two values.
You’ll want to make your view hidden because it will be pretty ugly to look at, especially if you use several fields as your key.
hth
Dana