Relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joy Rose - 23 Aug 2004 18:30 GMT

Relationships between tables are listed as one to many and many to many and
one to one. What if they are related without one of these chosen? What
happens to the text.

Reply to this Message

Brendan Reynolds - 23 Aug 2004 18:22 GMT

If you don't specify a relationship type, Access will try to guess. If there
is a unique index on the field(s) on one side of the relationship only, then
the relationship can only be one-to-many. If there are unique indexes on
both sides of the relationship, the relationship can only be one-to-one.
Otherwise, the relationship will be 'indeterminate' and you will not be able
to enforce referential integrity on that relationship.

I'm not sure what you mean by "what happens to the text" (what text?) but
basically, if the relationship is indeterminate, referential integrity can
not be enforced, and as far as I am aware nothing happens - to the best of
my knowledge a relationship that does not have referential integrity
enforced does nothing.

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

> Relationships between tables are listed as one to many and many to many and
> one to one. What if they are related without one of these chosen? What
> happens to the text.

Reply to this Message