Recreate Table Relationships

  • Thread starter Thread starter JerryS
  • Start date Start date
J

JerryS

I have a corrupt database. Now,I am recreating/rebuilding it. When I add
the relationships, some tables work while others I can not establish the
relationship even though I have the tables exactly the same as the tables I
have created them from.
I have 1-M and M-1 and M-M relationships. Suggestions as to how and what I
should look at as to why I can not create the relationships would be
appreciated.

Thanks in advance,....
 
When I add
the relationships, some tables work while others I can not establish
the relationship even though I have the tables exactly the same as the
tables I have created them from.
Click to expand...

Why not? Is it because the relevant options are dimmed out (in which case
some of the data types no longer match), or because of a "key violation"
error message. This latter is likely after a file corruption because some
records may have been lost and orphaned the keys at the other end of the
relationship. You may have to prune these by hand, or by a non-matching
query.

HTH


Tim F
 
Hi Tim, not that the options are dimmed out, the box at the bottom says
'indeterment'. Some of the tables have compound keys. I have no
documentation of what the original person who built the db was doing, so I
am guessing at the best way to setup the relationships.
 
Back
Top