If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. "Joy Rose" wrote in message ... 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. |
#2
|
|||
|
|||
Relationships
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disappearing relationships | Dan | Database Design | 2 | August 6th, 2004 06:43 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |
Relationships | SCHNYDES | General Discussion | 5 | June 9th, 2004 11:21 PM |
removing relationships. | FFira | General Discussion | 1 | June 4th, 2004 05:33 AM |
Table Relationships Design | Tom | Database Design | 1 | May 5th, 2004 11:56 PM |