I have one table with an auto-number field which creates an employee ID. I have another table where I want an employees name to appear rather than the ID. How can I convert these ID numbers into a name?
I have one table with an auto-number field which creates an employee ID. I have another table where I want an employees name to appear rather than the ID. How can I convert these ID numbers into a name?
Really should not work directly with tables/queries for viewing/editing data. Build forms and reports.
Save the ID into 'other' table and build query that joins the two tables.
Could build lookup in the 'other' table but I don't recommend this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Also,
Not a good design idea if it really is an automunber type field.I have one table with an auto-number field which creates an employee ID
See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers
Especially #6 under "What they are NOT" and also at the bottom -> 1 through 5.