How to build a query that if two columns in one table matches....

[austin]

.... then it creates a field that combines one of them with a coded value for the other?

In other words, I have two tables, one has two columns: the beginning of a sku number (call it "SkuBase"), and a number 1 through 4 for each specific SkuBase. Example:
(table has been censored to protect sensitive information)



The other table has a list that defines what number is associated to an additional sku part.
Example (in this table, the middle column doesn't matter, but the first column is named the same as the second column in the first table):



I need to take each value in the first table first column, and add to it the two letter code that's associated to each number. For example, in the first table, I need the first values in the new field to look like:
(* represents values hidden)
CH*****-30-MB
CH*****-30-GB
CH*****-30-BS
CH*****-30-FB

I understand what needs to happen, and I keep getting close. But as I have a bit of experience with Excel but none with Access, I would love to learn how to use access, especially to do this. Any help would be great, thank you!

[ranman256]

in a query:
join tSkuBase table to tSkuPart table on [single#] field
then in the query make a new field via:

NewPart: tSkuBase.[sku#] & "-" & tSkuPart.[2Ltr]

[austin]

Thank you!....but, how do you join?

[orange]

Info on JOIN