I am new to access and I am trying to create a database to do a lookup and populate a column with values. So I have one table with a column of colors, in table 2 i have those same colors with all duplicates removed and in the column next to it, I assigned a numeric value to each color. I want to populate the table1 with the values from table 2 by matching the color values. I googled creating lookups but I think I am going in the wrong direction.
Bookmarks