relationship questions

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

Slez via AccessMonster.com

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!
 
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
 
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.
 
"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.
 
Back
Top