how to make a database relational via a query

[David Schwartz]

I've got a single table where one of the fields has duplicate values (Field
A). I'd like to eliminate this redundancy. Do I have to manually associate
the various records with each unique value held in another, separate table.
The goal, of course, is to construct a relational solution. Is there a way
to automate this?

Thanks in advance,
David

 

[Mike Painter]

I've got a single table where one of the fields has duplicate values (Field
A). I'd like to eliminate this redundancy. Do I have to manually associate
the various records with each unique value held in another, separate table.
The goal, of course, is to construct a relational solution. Is there a way
to automate this?

Thanks in advance,
David

First, duplicate values in a field do not mean the table is not part of a
relational database.

You can cut and paste a copy of the table, then select structure only.
Place an index on the column and don't allow duplicates.

Do an append query from the old to the new and the duplicates will be gone.

The danger of this is that you have no control over which row gets deleted.

 

[Van T. Dinh]

There is the Menu command Tools / Analyze / Table that you
can help you to normalise the Table.

However, make sure you understand the Relational Database
Design Principles and the Database Normalisation so that
you can decide what is right.

HTH
Van T. Dinh
MVP (Access)