Automatic Field Entry

[Guest]

I have created a Form. This form is pulling information from an Employee
Information Tbl. The Tbl has the following fields: Last Name, First Name,
State, SSN & Date Hired. I would like all of the fields to be automatically
filled in once I have entered in the SSN.
There is also another Table that the Form is pulling from called Instructor
Information. There are 2 fields in this Tbl called: Instructor &
Wage/Salary. I am going to us a Combo box for the Instructor and would like
to have his/her Wage/Salary entered into the Wage/Salary field once the
Instructor is selected.
All of the information will be stored into a main Tbl called WEDNET Table.
How can this be done?

 

[John Vinson]

I have created a Form. This form is pulling information from an Employee
Information Tbl. The Tbl has the following fields: Last Name, First Name,
State, SSN & Date Hired. I would like all of the fields to be automatically
filled in once I have entered in the SSN.
There is also another Table that the Form is pulling from called Instructor
Information. There are 2 fields in this Tbl called: Instructor &
Wage/Salary. I am going to us a Combo box for the Instructor and would like
to have his/her Wage/Salary entered into the Wage/Salary field once the
Instructor is selected.
All of the information will be stored into a main Tbl called WEDNET Table.
How can this be done?

It SHOULD NOT be done.

Storing data redundantly in a second table is neither necessary nor
wise. The name and date information should exist in the Employee
table, *and only in that table*. You're using a relational database -
use it relationally!

To *display* the employee information on the Form, include all the
fields in a Combo Box; use textboxes with control sources such as

=comboboxname.Column(n)

where n is the zero based index of the field you wish to see.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps