T
thefonz37
My set-up is this: I have two tables, one with Employee Name, ID, Date of
Hire, etc., and another table with Employee Logins and Employee IDs. These
two tables are related through the Employee ID field and there are cases
where an employee has multiple logins, so the relationship is one-to-many
between the tables.
I've designed a form from the Employee Information table with a subform for
the login data embedded. What I would like to do know is create a listbox
(or a combobox, I suppose) where you can click on the name and the employee
information will populate into the form for editing.
Any ideas on how to do this? I had been looking up cascading combo boxs,
but I'm not sure this is the right way to accomplish what I want to do.
Hire, etc., and another table with Employee Logins and Employee IDs. These
two tables are related through the Employee ID field and there are cases
where an employee has multiple logins, so the relationship is one-to-many
between the tables.
I've designed a form from the Employee Information table with a subform for
the login data embedded. What I would like to do know is create a listbox
(or a combobox, I suppose) where you can click on the name and the employee
information will populate into the form for editing.
Any ideas on how to do this? I had been looking up cascading combo boxs,
but I'm not sure this is the right way to accomplish what I want to do.