How do connection two different tables fields?

Question

I am working on a ms access 2000. i have created 2 tables for employee one(table1) has emp id, emp name and another one table(table2) has emp address etc..Now i want to relate these two tables using the emp id. if i entered the emp id in table1, that has to table2. Pls any help me to solve this?? Thanks

Answer 1

Use the equation ='Work Sheet Name'!Cell
as in
='Employee Table 1'!A5

Answer 2

Go to tools and then relationships. Select the two tables and then create a link between the two. Make sure it is using the emp id, and it will probably be a one-to-one. This will relate the tables in Access.