Auto fill in data in access 2007

Microsoft Access 2007
March 11, 2009 at 14:32:52
Specs: Windows XP
I have created a time card database that calculates total hours. Also, I have two tables employees and time cards. In the employee table all of their info is stored employee number, name, ssn, etc. In the time card table is their name and number and places to input hours worked. The time card table looks up the info from the employee table.
In the time card form I would like to select the employee number and the name comes up automatically. How can I do this?

See More: Auto fill in data in access 2007

Report •

March 15, 2009 at 16:42:15
Having the name in the second table is redundant. Use the SSN as the Primary Key and use that as a Foreign Key in the second table.

Create a query using the first table. Then, create an input field that asks for the SSN. Then, create a form based on that query.


Report •
Related Solutions

Ask Question