Is it possible to populate a field in a table based on the entry of one of three user id's in another field?
I would like to populate the name field in Table 1 that associates to the Identifier based on the information in Table 2.
<tbody>
</tbody>
<tbody>
</tbody>
All help welcome.
I'm between a basic and intermediate user of Access.
I would like to populate the name field in Table 1 that associates to the Identifier based on the information in Table 2.
Table 1 | |
Identifier | name |
1234 | |
4321 | |
axl001 | |
dxl001 |
<tbody>
</tbody>
Table 2 | |||
EmpID | UserName | UserCode | Name |
1234 | axl001 | al4321 | Al |
4321 | dxl001 | dl1234 | Dave |
<tbody>
</tbody>
All help welcome.
I'm between a basic and intermediate user of Access.