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
|
|||
|
|||
relationship questions
I have...or had...a one-to-many relationshiop between 2 tables that no longer
is shown by join lines in the relationship window. When I try to add the relationship back in, it lists the join type as "Indeterminate", yet the database is functioning properly and all records seem to be related properly. What would cause a relationship to delete itself? How can the records be relating with apparently no set relationship? Any suggestions on how to go about restoring this relationship to "one-to- many"? Thank you! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200704/1 |
#2
|
|||
|
|||
relationship questions
Nevermind my previous post. I don't know how this came about, but my parent
table no longer had a primary key, so it wouldn't allow a one-to-many relationship. Creating the primary key fixed the problem. Slez Slez wrote: I have...or had...a one-to-many relationshiop between 2 tables that no longer is shown by join lines in the relationship window. When I try to add the relationship back in, it lists the join type as "Indeterminate", yet the database is functioning properly and all records seem to be related properly. What would cause a relationship to delete itself? How can the records be relating with apparently no set relationship? Any suggestions on how to go about restoring this relationship to "one-to- many"? Thank you! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
relationship questions
Are both fields named the same? If so Access assumes that this is the link
between tables. If the linking field in the One table also the primary key? If not it could cause it to be Indeterminate. In fact you probably need to enable Referiental Integrity to get it really locked down. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Slez via AccessMonster.com" wrote: I have...or had...a one-to-many relationshiop between 2 tables that no longer is shown by join lines in the relationship window. When I try to add the relationship back in, it lists the join type as "Indeterminate", yet the database is functioning properly and all records seem to be related properly. What would cause a relationship to delete itself? How can the records be relating with apparently no set relationship? Any suggestions on how to go about restoring this relationship to "one-to- many"? Thank you! |
#4
|
|||
|
|||
relationship questions
"I don't know how this came about, but my parent table no longer had a
primary key..." Just an FYI for future readers: I've found that the primary key can be removed *sometimes* when a record in the table corrupts. After Access Repairs/Compacts itself the "repaired" record that is left in the table (which is generally useless now) breaks the primary key rule and Access removes it. All you need to do is delete the junk "repaired" record and then reset the primary key. |
Thread Tools | |
Display Modes | |
|
|