Getting the Description from a view onto a form

HCL Domino Domino Forum
1

I’m creating a form that includes Product Code and Product Description. On my form Product Code type is a dailog list that retrieves the codes from a view. How can I then populate the Product Description field on the same form ? The description exists on the view.

Hope this makes sense !!

Many Thanks

Cheers

2

Subject: Getting the Description from a view onto a form

Simple lookup.

Make sure the product code is unique.

Make sure it is in the first sorted column of the view you want to use for your lookup.

Then, use an @DbLookup to retreive the value of the description in that view, based on the selected code.

Search Notes Designer help for @DbColumn, @DbLookup and @Picklist for a starter.

Good luck!

Nicolas Abesdris

Quintessence e-solutions Inc.

3

Subject: Getting the Description from a view onto a form

Try

REM $ProductView is a view has two columns - Product Code and Product Description

ProductDscription:=@DbLookup(“”;“”;“$ProductView”; ProductCode; 2);

ProductDscription