Recreate Table Relationships

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,....
 
T

Tim Ferguson

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.

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
 
J

JerryS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top