Lookups from forms

How do I make a form so that when a name is entered it looks up the department from the NAB and populates a department field, but if a name is not found it leaves the department blank?
You can use a formula in the input translation area of the field to do a DBlookup on the fields value and populate another field. For example" @SetField(Department; @DBLookup("Notes";"";"myview";name;"Department"))
This was first published in December 2003

Dig deeper on Lotus Notes Domino Formula Language

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.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • 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 ...