Posted on 2004-08-11
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 !!