Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Auto fill in data in access 2007

Comment:

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?

Name: Jennifer SUMN
Date: March 15, 2009 at 16:42:15 Pacific

Reply:

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. EEOC

0

Sum total of two records

Error from linux pc

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am writing a point of sale program in Access 2007 and need to include a way of firing a cash drawer from the program. As I haven't obtained the drawer yet I have the choice of getting a serial or RJ...

Summary: I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field. Specifically, I want a Region field to fill in automatically based on what is put in the Cou...

Summary: ok, in excel i know there's a feature called FIND (Main menu ->Edit->find) which helps one locate words/features in the datasheet. but my question is do we have such in MS Access? the point is that i...