B
Brendan Reynolds
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.
--
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.
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.
--
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.