I am trying to do a simple dblookup on a dialog list field, but keep getting "File does not exist"error no matter what I do or change.
Here’s the formula:
@DbLookup(“”:“NoCache”;“H:\notes\data\mbapropo.ntf”;“Proposals\by Date”;CustomerName;“CustomerName”)
It’s on Local database.
Subject: @dblookup → “file does not exist”
Coupla problems – no server, and not enough backslashes (you need 2 to get 1). And if the user’s Notes data directory is on their H: drive, then it’s at “Notes root”, so the formula should probably have been:
@DbLookup(“”:“NoCache”;“”:“mbapropo.ntf”;“Proposals\by Date”;CustomerName;“CustomerName”)
And you’ll probably find that you don’t need NoCache – you almost never need it, and it just means you do repeated lookups for nothing every time the form is refreshed/saved.
Subject: RE: @dblookup → “file does not exist”
Thanks for the quick answer,as soon as I added the null server
parameter, it worked - at some degree, at least.
And good to know about that NoCache,
I kept it on just in case it would be causing
some of the problems due to not refreshing data
every time.