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

Back to top