Dblookup

I’ve got this code residing as the default value of a computed text box:@DbLookup(“”:“NoCache”;“”:“”;“(embOwnerPhone)”;O_UID;“Owner Phone”)

(embOwnerPhone) = view name

The first sorted column of this view has O_UID as the target field from a form called Owner card

O_UID is the key field on the current document.

It looks to be populated with the right information.

Owner Phone = the column heading in the “(embOwnerPhone)” view that I want to retieve data from.

It returns nothing….

Am i missing something here?

Thanks in advance

Jim Lamb

Subject: dblookup…

The column heading is meaningless drivel intended for puny humans to read with their underdeveloped brains. You have to use either the column number or a fieldname.

Subject: RE: dblookup…

Thanks, Stan. I almost fell out of my chair from laughing when I read that first sentence.

I assume that that came directly from the Notes help file. :slight_smile: