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

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"))

Dig Deeper on Lotus Notes Domino Formula Language

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