"Gregc." <gr*********@bigpond.comwrote in
news:11**********************@b28g2000cwb.googlegr oups.com:
pi********@hotmail.com wrote:
>How did you get more than one copy of a table in the
relationships window without putting it there yourself? Please
explain. And what happens if you just delete the tables from the
relationships window you don't want there?
I don't know how it happened. I certainly didn't put them there
(the duplications). When I delete the duplications, save the
changes, and re-opened the database they re-appear.
Deleting the table from the relationships window does not remove the
relationship it represents. Delete the relationship and then delete
the table.
But you need to consider whether or not the relationship is needed
or not. If it simply duplicates an existing relationship, then it
can be deleted, but if it is a unique relationship, it has to
remain.
--
David W. Fenton
http://www.dfenton.com/
usenet at dfenton dot com
http://www.dfenton.com/DFA/