Problem solve Get help with specific problems with your technologies, process and projects.

Access Notes database field from @dblookup

I have specified the departments of all the employees and now I want to access that field from Notes database to a form through @dblookup. Kindly give some solution?

You must create a view that contains the field you would like to lookup in the FIRST SORTED column in the view.

I've included an example, given the following assumptions;
- The sorted view is called "LookupView"
- The field you are looking up is called "empDepartment"
- The variable CurrentDept contains the Key you are using
- If you are looking to the current database, you can replace the argument for "ServerName":"DatabaseName" with two quotes "".

CurrentDept := "SalesAndMarketing";
EmployeesInDepartment := @DBLookup( "Notes":"Cache" ; "ServerName":"DatabaseName" ; "LookupView" ; CurrentDept ; "EmpFullName" )

Dig Deeper on Lotus Notes Domino Administration Tools

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...