relationships between tables

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

Hello,

It seems that I can define relationships between fields in different tables
either using the 'Relationships' window, or in the design window of a query.

What is the difference? Do relationships apply only to a particular query or
form, or are they permanent?

Thanks

KK
 
The relationships you establish in the relationships window will
"pre-connect" your tables when you use queries involving them.

Much more importantly, from a database integrity standpoint, you can use the
relationships window to establish referential integrity between your related
tables. This will ensure, for example, that you can't have a "child" (many
side) ID as a foreign key in your "parent" (one side) table unless there's
a child ID record in the child table.

That way, you don't get records that "point" to other tables' records that
don't exist.
 
It seems that I can define relationships between fields in different
tables
either using the 'Relationships' window,
Click to expand...
These are permanent relationships
or in the design window of a query. These are for the query only.

What is the difference? Do relationships apply only to a particular query
or
form, or are they permanent?
Click to expand...

hth
Marc
 
Back
Top