Question Relationships

[jc_]

This is a pretty basic questions, but if I am given many tables and am told to create the relationships, I know how to do that on access, but how do I know which tables to connect?

 

[RainLover]

When you designed the Tables you set up a Primary Key in each Table.

In some Tables you also set up a Foregin Key which equals the Primary Key in another Table.

Join these together. And don't forget to enforce Referential Intregity.

 

[jc_]

Oh, okay! But he primary key has the key picture next to it; is the foreign key identified in any way?

 

[Beetle]

The foreign key would typically be named in a way that would give some indication as to which field it is related to in another table. For example, say you have a Customers table and an Orders table;

tblCustomers
**********
CustomerID << Primary Key of tblCustomers
FirstName
LastName


tblOrders
*******
OrderID << Primary Key of tblOrders
CustomerID << Foreign Key to tblCustomers
OrderDate

It would also need to have a compatible data type. Did you design these tables?

 

[Beetle]

Should I say something about great minds

Hey! I was just about to say that.

 

[RainLover]

While it is True that great minds think alike it is also true that

Fools Seldom Differ.