I have a DialogList field called Division which gets the list of divisions listed in the first column of a specified view with a @DBColumn which works fine. The Division field is also set to refresh on content change. However, I also have another DialogList field called “ProjectManager” with the following formula which does not work:server:=@Subset(@DbName;1);
db:=“NAMES.NSF”;
view:=“vLookupTechLeadByDept”;
key:=Division;
col:=2;
place:=“-Select a Project Manager-”:“-Not Applicable-”;
result:=@DbLookup(“” : “NoCache” ; server : db ; view ; key ; col);
@If(result=“” | @IsError(result) ; “ERROR” ; place : result)
Can someone tell me what I am doing wrong here? This doesn’t work in either the web or the Notes client environment.
Thsnks,
Dan