Need help with a notes client database. I have created a form that has three fields.
- ProgType, 2.ApproverTitle & 3. ApproverName
lets call it FORM_Approver
I have created a view “ApproverListView” where I display these recored created using FORM_Approver with three columns 1. ProgType, 2.ApproverTitle & 3. ApproverName
Now in my main form the user needs to select Fiveapprovers .
The user first selects the “ProgType”. Now using @dbLookup I have the user view the corrosponding ApproverTitles in the five desired fields.
Now here is the question.
Once the user selects the approver title say in field “ApprTitle_1” I want the adjcent field (ApprName_1) to grab the corrosponding Approver name from the same row of the view “ApproverListView” and auto poulate this field(ApprName_1).
Any help will be greatly appreciated.
Thanks in advance.