DBLookup of 1st Column While Saving 2nd Column Value

Author: Tripp W Black

Created: 04/03/2000 at 09:34 AM

 

Category:
Notes Developer Tips
Formulas, Views

You do not have to do the second dbLookup, since you are returning value from the same view.

Instead of choosing column "1" in the @Picklist formula of yours, you can directly choose "2", though the user would be searching for value on the 1st column.
So your formula should be:

FIELD field_name :=
@PickList([Custom]; "Server":"Path\\Database.nsf"; "(Hidden View)"; "Title" ; "Selecte Message" ; 2);

previous page