I have replicated my server stored database to a local PC. The database contains
DbLookup in the format:-
The problem is, it only works when opened from the server, not locally.
Is there any way a getting it to work locally as well?
The formula is in the correct format and should work. The problem probably relates to an access related issue. Check the view and make sure you can see documents in the view. If you can't, you may need to be in a group or role to allow you to access the view and/or its documents. These may not apply if the ACL is not consistent. You may have to enable the Advanced ACL setting: Enforce a consistant Access Control List across all replicas of this database.
This was first published in June 2001