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.