@dbLookup field ... value is a constant '1' ??
Posted on 2002-04-16
Have a form with three fields....Requested By <ReqBy>, Requested by Phone <ReqbyPhone> and Requested by Division <ReqbyDiv>. The Requested by field is a dialog list, editable, choose from Address book dialog. The Requested by Phone and Division are to be populated dependant upon the choice made in the Requested by field....using an @dbLookup formula...
@If(ReqBy !="") ;
lkupVal := @dblookup("Notes":""; "123.nsf"; "People"; ReqBy; 2);
Field ReqbyPhone := @word(lkupVal;"Y";1);
Field ReqbyDiv := @word(lkupVal;"Y";2);
So when I test the form, the fields ReqbyPhone and Division show the value '1' and are not changable. These two fields are text /computed...
What have I done wrong now?
help :) thanks in advance