Joining Tables Vlookup equivalent?

[Guest]

I have two tables. Table1: Transactions and Table2: Customers
There are many transactions per customers. There is a unique identifier
"Customer ID" column in both tables. However, there is one column in the
Customers table called "Zipcode".

How do I edit my Table1 to insert a column called "Zipcode" that will link
up from Table 2? I can do this in excel by using index/match or vlookups but
I want to do this straight in Access. Any ideas?

 

[Stephen Glynn]

I have two tables. Table1: Transactions and Table2: Customers
There are many transactions per customers. There is a unique identifier
"Customer ID" column in both tables. However, there is one column in the
Customers table called "Zipcode".

How do I edit my Table1 to insert a column called "Zipcode" that will link
up from Table 2? I can do this in excel by using index/match or vlookups but
I want to do this straight in Access. Any ideas?

You don't want to store the Zipcode (or anything other than the
CustomerID) in more than one table.

Just write a query joining both tables on the CustomerID field in a
one-to-many relationship between Customers.CustomerID and
Transactions.CustomerID. Your query results will then display all the
fields you want to include from tblCustomers that are relevant to the
particular transaction you're looking at (and vice versa).

BTW, it's not a good idea to include spaces (or punctuation characters)
in field names, since this confuses Access no end.

Steve