By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,590 Members | 663 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,590 IT Pros & Developers. It's quick & easy.

Duplication of Tables

P: n/a
Hi

I have put together a database, with mulitple tables. The tables are
joined via a relationship. For some reason MS Acces, are duplicating
the tables, within the relationship window. Is there a way to over
come this.

Greg

Aug 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?

Aug 3 '06 #2

P: n/a
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.

Greg

Aug 3 '06 #3

P: n/a
"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/
Aug 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.