@dblookup formulas driving me crazy

[shanef1981]

Hi guys,

I used to do a lot of access stuff thru here under a different handle which I lost, so I'm used to the forums

Now, my new employer wants me to use Notes/Domino 6.5 instead of Access/SQL, so as you can imagine I'm having loads of fun...

Firstly, just to clarify... can a dblookup be used in a view column at all? I have one database (ARInv.nsf) which needs to be cleared out and refreshed daily with fresh invoice data from our in-house systems.

This in turn needs to be able to reference the Account Managers database (ARManage.nsf) which has a list of the Account Managers and which Account numbers and Product lines they handle.

What I have done so far is to have a composed column in each database to display basically a strung together Account Number and Product code, this column I have called AccountP in each view/database.

When I try to use the following lookup in a view column to get the Account Manager:

@DBLookup("Notes":"NoCache";"":"ARManage.nsf";"Managers";"AccountP";"Manager")

What I gather from this is that it will lookup the ARManage.nsf database in the "Managers" view and use the "AccountP" column as a key to find the relevant "Manager".

When tried in practise I get an error message:

"Field: 'Manager': Entry not found in index or view's index not built"

This sounds rather alien to me... I might be doing something rather dumb, but any help I can get on this would be great...

Thanks

 

[shanef1981]

Don;t worry about this guys, I sorted it, ended up being a syntax error, how blonde of me...