Duplication of Tables

[Gregc.]

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

 

[John Vinson]

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

What's duplicating is the *table icons* - the images showing the name
and fields of the table - not the tables themselves. This often
happens when you have duplicate relationships, e.g. two different
relationships joining the same pair of tables. One way this can happen
is if you're misled into using Microsoft's misdesigned Lookup Wizard;
it will create relationships between the main table and the lookup
table, even if such a relationship already exists.

You can get rid of the excess relationships (and the table icons) by
selecting the *join lines* - not the table icons, but the lines
connecting them - in the relationships window; click the Delete key on
your keyboard and say yes when asked if you want to drop the
relationship. "Orphaned" table icons can then be selected and deleted.
Compact the database when you're done to recover the space occupied by
the redundant indexes.

John W. Vinson[MVP]

 

[Gregc.]

What's duplicating is the *table icons* - the images showing the name
and fields of the table - not the tables themselves. This often
happens when you have duplicate relationships, e.g. two different
relationships joining the same pair of tables. One way this can happen
is if you're misled into using Microsoft's misdesigned Lookup Wizard;
it will create relationships between the main table and the lookup
table, even if such a relationship already exists.

You can get rid of the excess relationships (and the table icons) by
selecting the *join lines* - not the table icons, but the lines
connecting them - in the relationships window; click the Delete key on
your keyboard and say yes when asked if you want to drop the
relationship. "Orphaned" table icons can then be selected and deleted.
Compact the database when you're done to recover the space occupied by
the redundant indexes.

Thanks for your advice, it was most helpful. Could you direct me to
some really good books on the in's and out's of MS Access.

Thanks

Greg

 

[John Vinson]

Thanks for your advice, it was most helpful. Could you direct me to
some really good books on the in's and out's of MS Access.

You almost gave the title:

Microsoft Access Inside Out, John Viescas (Microsoft Press)

Actually there are quite a few good books. Learning styles differ;
what might be good for me might not for you. I'd suggest going to a
*good* bookstore with a big technical section, and sit down with half
a dozen Access books. Leaf through them, and/or try to find an answer
to some specific question ("using a combo box to find a record" for
instance). See which work well for you.

John W. Vinson[MVP]