DBLOOK UP Lotus Notes Designer

have a view using DbLookUp to find a field, however, the field is not categorizing. I looked at another posting which stated that DbLookUp fields cannot be categorized unless they are in the far most left column. I changed my view, so that the DbLookUp field is in that column. The field is still not categorizing. Any thoughts?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I am not sure if I understand your problem fully. I am offering some generic help. Perhaps that will help.

To use DBLookup on a view the view should meet these conditions:

(1) The View must be sorted on the first column (left most). Categorized or not, does not matter.
(2) The first column must contain values based on formula to be looked up. It can be a single field value or a composite made out of many fields put together.
(3) The view must contain the column that contains the return value.

Now compare this with your scenario. Do you see any gaps?
christie_holtzAuthor Commented:
I have a view called 'External Summary'.  On that view, I have the following fields, Reviewer, Quarter, PC,and Name.  I am using a DBLookUp for Reviewer.  The DBLookUp code is @DbLookup("";"";"intlookup";qtrid;int_onc).  I am tryin to get int_onc from another view called 'Internal Summary', the field there is called int_onc, but labeled Reviewer. This field is the first column in the view and is sorted.  
Does this help?
Are you trying to use Dblookup in view column formula, If yes then it will not work. From your dblookup, this is what i infer

Intlookup - is the view name
qtrid - key
int_onc - value to be fetched

qtrid i am not sure what you have in that

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

christie_holtzAuthor Commented:
Yes, I have my DBLookUp in the column's formula section.  Since that won't work, what would you suggest I do?
Create a field in the current document which will evaluate to this dblookup: something in this line:

Create a agent and put this code and run on all the documents

I am assuming that int_onc and qtrid are there in that document

field newdblookupfieldname:=@DbLookup("";"";"intlookup";qtrid;int_onc);  


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
christie_holtzAuthor Commented:
I am totally new to LN....I think this might be out of my league.....when I copy that code and put it into an agent....when I go back to it the code as a SELECT statement in there....what does that mean?
Sjef BosmanGroupware ConsultantCommented:
Could you please explain what you want to accomplish, in logical terms, or in terms of output? E.g. "I want to show X, Y, and Z on one line, where X and Y come from one document and Z comes from the other".

As you may have found out the hard way (which is unfortunately the best way), Notes is by no means a relational database. If you explain your view in some relational SQL-select statement, we can see if it is easy to do. You have to accept that, in Notes, data sometimes must be duplicated to other documents (records) in order to ascertain relationships, and that you have to maintain these relationships yourself.

Notes add select @all after any statement, Forget that and run on selected documents,

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.