M
MCJ
I am putting together a Call Log database in Access 2000. So far here
is the setup: I have a table (Employees)in another database linked to
the Call Log database. The employee database contains Employee name,
username, phone extension, department, and email address.
The Call Log form has the same fields that are in the employee
database. When I log a call I select the employee name from a drop
down list (combo box), and I manually fill in the rest of the data
(ext, dept). What I would like to do is have the other fields
automatically fill in once I select a user name. So when I select Jane
Doe from the drop down list, I want her phone extension, username,
dept, and email address to automatically fill in.
I really have no idea how to accomplish this. Any help would be
appreciated.
Thanks
is the setup: I have a table (Employees)in another database linked to
the Call Log database. The employee database contains Employee name,
username, phone extension, department, and email address.
The Call Log form has the same fields that are in the employee
database. When I log a call I select the employee name from a drop
down list (combo box), and I manually fill in the rest of the data
(ext, dept). What I would like to do is have the other fields
automatically fill in once I select a user name. So when I select Jane
Doe from the drop down list, I want her phone extension, username,
dept, and email address to automatically fill in.
I really have no idea how to accomplish this. Any help would be
appreciated.
Thanks