Query to add Nick Names 1

[gabber4858]

Hi everyone! I have been trying to wrap my head around this, but have not had any luck. I started with 2 tables, table 1 is names to look up and table 2 is the company directory (20K records).

I have now created a 3rd table called nickNames and have the common nick names for people. Ex: Thomas Tom Tommy.

I want to compare the first names of the Company Directory and add new records with the respective alternate names if they are found in my nickName table.

I can then use a compare query with the lookUp table against the new company list and get the employeeID and computer name, etc for users accounts that used a nick name instead of their proper name.

My head is exploiding, this is probably easy, but I have to have it by the end of the week.

Thank you in advance for any suggestions.

 

[SkipVought]

hi,

Why not just join the tables when you query, rather than adding rows to your employee table? Nothing really has to change. It will be much easier to maintain your nickname table than maintain the same data in your employee table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gabber4858]

Sorry, I still do not understand. I might not be explaining this correctly. My table(s) look like:

Employees
ID
lst_name
frst_name
employee_ID
dept_number

NickNames
ID
nick_name
proper_name

So... say I have an employee named Jim Smith, I would like to take this record from the Employees table combined with the NickNames table to create a new list that takes all the NickNames and combines the other info.

Smith Jim 12345678 555
Smith Jimmy 12345678 555
Smith James 12345678 555

This way, I can query my lookup list against my newly created all_name list and find a user no matter which way their name was entered.

I am def open to other suggestions.... thanks again

 

[gabber4858]

yeah...... I'm an idiot. Thanks Skip! I guess I just needed to step away for a little bit.