Can you Update Data Automatically?

[scottyandpear]

Hope Someone can help.

I am fairly new at Microsoft Access. I have setup a file in access 2002 called employee's. I made two tables in the file. One is called employee info and the other table is called personal info. I was wondering if there is a option in access to copy data from one table to the next table automatically. I want the first two fields in the employee info table "First Name" and "Last Name" to copy to the personal info table? For each table the first two field names are the same First Name and Last Name. Also the First name is the primary key in both tables.

Thanks

Scotty

 

[KenReay]

Hi

The short answer is yes, you can achieve what you are trying to do. There is as with most things more than one way to do it, one method is the use of mainform/subform contruct with linked fields.

What worries me (unless this is just a contrived example) is WHY you would want to do such a thing?, why repeat the data when you can achive the same result via a query?

Also you choice of primary key does not sound wise, there is quite a high probability of having two employees with the same FirstName.

My advice to you (and any one else new to Access) is learn some database design basics first (ie table design, normalisation, the theory of relational databases), it will save you a lot of tears in the future

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK