@dblookup -> "file does not exist"

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.