Linking tables

D

Dan

I am so new at Access. I can make several tables, customer, employee,
orders.... How do I link them together? When I input customer information,
how do I link the employee with it?
 
L

Larry Linson

Newsgroups are not the place for "basic Access training". For the raw
novice, I suggest starting with the self-study book "Microsoft Access Step
by Step" published by Microsoft Press.

There's an example database, Northwind.MDB, that comes with Access. You can
look at that to try to determine techniques, but there's no "beginner
course" that comes along with Access to lead you through it.

The Office Online link in Access 2003 Help leads to
http://office.microsoft.com/en-us/training/default.aspx where you might find
something useful.

Larry Linson
Microsoft Access MVP
 
R

Raghu Prakash

Hi Dan,

Create a relationship between tables (ADP)
You create a relationship between two tables when you want to associate
rows of one table with rows of another.

Create a relationship in a database diagram

In the Database window, click Database Diagrams under Objects, click the
database diagram you want to open, and then click Design on the Database
window toolbar.
In your database diagram, click the row selector for the database column
or combination of columns that you want to relate to a column in another
table.
While the pointer is positioned over the row selector, click and drag to
the related table.
Release the mouse button. The Create Relationship dialog box appears and
attempts to match the columns you selected with columns of the same name
and data type in the related table.
In the Create Relationship dialog box, confirm that the columns you want to
relate are shown in the Primary key table and Foreign key table lists.
Choose OK to create the relationship.
On the diagram, the primary key side of the relationship is denoted by a
key symbol. In one-to-one relationships, the table that initiated the
relationship determines the primary key side. For example, if you create a
relationship from the pub_id column in the publishers table to the pub_id
column in the pub_info table, then the publishers table is on the primary
key side of the relationship.

Create a relationship in Table Designer

Click Tables under Objects, click the table that is on the foreign key
side of the relationship, and then click Design on the Database window
toolbar.
Right-click in the Table Designer and choose Relationships.
Click the New button.
From the drop-down list in Primary key table, choose the table that will be
on the primary-key side of the relationship. In the grid beneath, enter the
columns contributing to the table’s primary key. In the adjacent grid cell
to the left of each column, enter the corresponding foreign-key column of
the foreign-key table.
The table designer suggests a name for the relationship. To change this
name, edit the contents of the Relationship name text box.
Choose Close to create the relationship.


For Further Information :
http://office.microsoft.com/en-us/assistance/HP030839911033.aspx

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top