dblookup problem

Hello All,
This is crazy.  I have worked with dblookup many times and I can't find the problem with this one.  Possibly the view.
I have a view that consists of data from 2 different forms.  The columns contain data from both forms.  here is my dblookup formula.
temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error";temp)

CCestXref is the view used.  Column 1 is sorted and contains change control numbers.  CCres_CCnum is the key I'm using on my 3rd form.  I'm looking to take all the values in column 3 of the 2 form view and place those values in the field containing this lookup on the 3rd form.  I keep getting lookup error. ??????
Please Help !!
Thanks !
Paul
LVL 4
pratiganAsked:
Who is Participating?
 
qwaleteeCommented:
To get the text of the lookup error, replace:

temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error";temp)


With:

temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error:"+@Text(temp);temp)
0
 
pratiganAuthor Commented:
Additionally...
The field on the 3rd form that contains the dblookup formula is a computed field allowing multi values and compute after validation.
Hope this helps.
0
 
qwaleteeCommented:
WHich lookup error are you getting?

If you open the view and type the key you are trying with, does it go to that row?

Does the matching row have an error value displaying in the view?  If there are multiple matches, check that:
1) None of them has an error displaying in the view
2) All have the same data type
3) Dn't forget that a blank number or blank date is a string, so if the datatype is, e.g., number, and one doc has true numbers but another has blank numbers (null strinG), you will not be able to look this up.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
pratiganAuthor Commented:
entry not found in index or views index not built.
0
 
pratiganAuthor Commented:
I understand that I get the error initially until I enter the lookup key number on the form, but then the field value should show up and the error go away once auto refresh fields.
0
 
pratiganAuthor Commented:
I got it. Ended up rebuilding the lookup view differently.  FOr having multiple fields from different forms I just listed those fields separated by a : and removed the test for what form it was.  The form didn't matter, I have the forms listed under the view selection area only now and it works great.
Thank You !
0
 
pratiganAuthor Commented:
Although I got it worked out, I'm still granting you the points for your help.  I will be posting another question looking for a simple export to Word keeping the same notes document format.
Thank You !!
0
 
qwaleteeCommented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.