Wondering

M

Mato

Good Day

I am wondering if it is possible for access to connect data from two tables
using a primary key number as the link and if so do I have to write a code
for the capability or just link the tables.
 
J

Jerry Whittle

Create a new query.

In the show table dialog box, select the two tables in question the click on
the Close button.

Next make sure that there is a line between the two tables on the fields
appropriate to join the table. If not, drag and drop from one field to the
other.

Add the fields that you want to see to the Fields row.

Run the query.
 
M

Mato

Thank you

Now I need to know if I can take a primary number from one table and use in
another table to connect data from one table to another.
 
A

a a r o n . k e m p f

It is called a join

you can also use the old-style ANSI clause
SELECT *
FROM Orders, OrderDetails
Where Orders.OrderID = OrderDetails.OrderID

I generally think that syntax is a little easier to catch-- than the
SELECT *
FROM Orders Inner Join OrderDetails
On Orders.OrderID = OrderDetails.OrderID

but if you do that-- I think that Access will just rewrite it to a
standard join

-Aaron
 
Top