Trying to access a field and withdraw information

HCL Domino Domino Forum
1

I am trying to access another db on the same server. I want to ask whether there are any matches to “ADT” within a company field, and if so, to print out the contents of the “ADDRESS” field from that company’s details. To do this, I am using this code, but it keeps coming up with error:

@If(@IfError(@DbLookup(“”:“”; @Subset(@DbName; 1):“ourconta.nsf”; “Contact”; CompanyName; 1); “Error”) = “ADT”; (@DbLookup(“”:“”; @Subset(@DbName; 1):“ourconta.nsf”; “Contact”; OfficeStreetAddress; 1); “Error”)

Is this code just silly, or is there something else fundamentally wrong that I’m missing?

Thanks in advance for your help.