D
DougW
I have a combo box where the user will select an employee from a Employee
table listing the employees with a lookup filed for the supervisors. The
supervisors' names are in a separate table, called Supervisors. What I am
trying to figure out is how, after a user selects the employee in the combo
box, can I use that information to populate an unbound text box with the
appropriate supervisor?
The combo box has two columns, the primary key from the Employee table, and
a name column which combines the first and last name fields so that it
appears as Lastname, Firstname to the user.
Am I making this too difficult? I am having trouble finding a solution to
even try!
Employee Table:
Primary Key, LastName, FirstName, Supervisor (lookup - pk from Supervisors)
Supervisor Table:
Primary Key, SpvsrLast, SpvsrFirst
table listing the employees with a lookup filed for the supervisors. The
supervisors' names are in a separate table, called Supervisors. What I am
trying to figure out is how, after a user selects the employee in the combo
box, can I use that information to populate an unbound text box with the
appropriate supervisor?
The combo box has two columns, the primary key from the Employee table, and
a name column which combines the first and last name fields so that it
appears as Lastname, Firstname to the user.
Am I making this too difficult? I am having trouble finding a solution to
even try!
Employee Table:
Primary Key, LastName, FirstName, Supervisor (lookup - pk from Supervisors)
Supervisor Table:
Primary Key, SpvsrLast, SpvsrFirst