Database relationships

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

In Tools->Relationships there is a setup for database relationships.

In form editing, clicking outside the form area, (data)RecordSource,
we have also access what seems to be a similar setup.

What is the difference between them?

Thanks

H. Martins
 
The Relationships window opened from the Tools menu is the place where you
define and view the relationships between your various tables. It is a great
way to stay on top of all the information about how your table connect to
each other, as well as the way you create the relationships with referential
integrity. Personally, I find that so useful that I've modifed the
relationships report (Access 2000 and later) so that it includes more
detailed information about the fields:
http://allenbrowne.com/AppRelReport.html

The most recent version of Access does let you get at the other tables
through the RecordSource property of a form/report. The idea is that you can
get fields from multiple tables as the source data, just as you can create a
query that contains multiple tables. You do not define/manage your
relationships here. You can join tables in particular ways (as you can in a
query), but you cannot manage the relationships.

If you are not sure about the difference, this old article that explains RI
might help:
Referential Integrity can't be that easy!
at:
http://allenbrowne.com/xbase-07.html
 
Back
Top