Hello...
I have two tables that looks (simplified) like this...
Table 1:
UniqueID - Name - City - State - Zip - Color
1234567 - Dell - small - CA - 80010 - BLUE
7654321 - MAC - Large - OR - 85214 - RED
Table 2:
UniqueID - Name - Occup - Title - State - Color
1234567 - Dell - Geniology - Analyst - CA - ??????
7654321 - MAC - healthcare - Athlete - OR - ??????
PROBLEM
I need to get the COLORS to table 2... (using the unique ID's as a reference between both tables).
Any help would be greatly appreciated.
THANKS
I have two tables that looks (simplified) like this...
Table 1:
UniqueID - Name - City - State - Zip - Color
1234567 - Dell - small - CA - 80010 - BLUE
7654321 - MAC - Large - OR - 85214 - RED
Table 2:
UniqueID - Name - Occup - Title - State - Color
1234567 - Dell - Geniology - Analyst - CA - ??????
7654321 - MAC - healthcare - Athlete - OR - ??????
PROBLEM
I need to get the COLORS to table 2... (using the unique ID's as a reference between both tables).
Any help would be greatly appreciated.
THANKS