@DbLookup only returning info. from first document

I am a bit of a Notes newbie, so be gentle :smiley:

I am trying to populate a dialog list with a subset of information in a view in another database (local for testing purposes).

View: “In plan IP”

The key is a field that the user first selects: “Request_Technology”

Pull in data from either column 2, or the field “IP”

The code looks like this: (use formula for choices):

@DbLookup(“” : “NoCache”; “” : “IP Tracking.nsf”; “In Plan IP”; Request_Technology; “IP” (or 2))

I have multiple values allowed.

The first column of my view is sorted, but the @dblookup is only reporting the first document, not all of them, and reporting them all semicolon seperated as I thought it is supposed to.

Thanks for any help,

–Jay

Subject: @DbLookup only returning info. from first document

n/m…I figured it out, the view I was trying to access was categorized which seemed to mess it up.