Auto fill information

[Endorphin]

Hi All,


I am a complete newb to Access, I have spent along time on Excel but the amount of data is to much now for what I want to do, so I thought it was time to explore Access.
I am starting simple.

I am trying to create a Staff locations database, very simple.....

The problem I'm having:

I have Table-1 with 3 fields in: Name, Phone & Manager
Table 2 has the same 3 as Table-1 plus others,
The Name field in Table 2 is a look-up of Name in Table-1

What I cannot find a way to do, is populate the Phone and Manager fields in Table-2 when a name is selected in the look-up of form for Table-2

Sorry for the complete Newb question, any help would be appreciated.

[June7]

Should not save the phone and manager data in Table 2. That would be duplication of data. Just save name, actually names make a poor unique identifier, better to use a StaffID number. Save the StaffID as foreign key in Table 2. Use queries that join tables to retrieve related data.