supportguy21
Technical User
Background:
I have created a Form (related table: SupportIssueLog) for support staff to enter trouble ticket information. One of the fields in this form is "Employee Name". In order to make this form more "user friendly" and to avoid misspellings, I wanted the support user to select the customer name from a (drop-down) list of names rather than typing them in.
What I did:
So I created another table called EmployeeList that contains the names and phone numbers of everyone in the company. I used the Lookup Wizard function on the "Employee Name" field so now, when the Support user clicks that field on the form, a list of company employees appears and the Support user can select the appropriate name.
The problem:
The Lookup Wizard only seems to work with a single field - I want to return info for multiple fields.
Specifically, I would also like to auto-populate another related field in the form called "Phone No.". So - when the Support User selects a name from the drop-down, both the "Employee Name" and "Phone No." fields in the form are auto-populated with the correct info (based on the EmployeeList table.).
I have created a Form (related table: SupportIssueLog) for support staff to enter trouble ticket information. One of the fields in this form is "Employee Name". In order to make this form more "user friendly" and to avoid misspellings, I wanted the support user to select the customer name from a (drop-down) list of names rather than typing them in.
What I did:
So I created another table called EmployeeList that contains the names and phone numbers of everyone in the company. I used the Lookup Wizard function on the "Employee Name" field so now, when the Support user clicks that field on the form, a list of company employees appears and the Support user can select the appropriate name.
The problem:
The Lookup Wizard only seems to work with a single field - I want to return info for multiple fields.
Specifically, I would also like to auto-populate another related field in the form called "Phone No.". So - when the Support User selects a name from the drop-down, both the "Employee Name" and "Phone No." fields in the form are auto-populated with the correct info (based on the EmployeeList table.).
