Relatioships between table in a database?

[rusty]

help

can someone please explain in the most simple way they can. about how to
create relationships between tables in a databse.

my college tutor is no help.

so if any one can help i would be eternaly grateful to them.

 

[Rick B]

Microsoft has a tutorial that might help. Paste the following (all of it)
into your browser.

There are lots of good tutorials at that site.

http://office.microsoft.com/trainin...ID=RP061827081033&CTT=6&Origin=RC061183261033

 

[Jeff Boyce]

Rusty

Open an Access database.

Click on the <Tables> tab.

Click on the <Relationships> toolbar button.

Add Table1 to the Relationships window.

Add Table2 (a related table - i.e., it has field pointing back to a field in
Table1)

Drag Table1's field and drop it on top of the corresponding/matching field
in Table2.

Repeat as needed for other table relationships.

Regards

Jeff Boyce
Microsoft Office/Access MVP