How will I do this?

[smask]

Hi!

I've got a table with IN that contains Customer ID etc.. In an other table I've got Customer ID and Customer name.

Now I want to create a Query that displays Customer name next to its ID.

Ball Blue 7124 Mike's Inc

How will I do this?

 

[llkhoutx]

Build a query containing both tables, linking CustomerID in both tables, i.e. dragging CustomerID from one table over onto CustomerID of the other. Then select desired field to be displayed.