Normalize a table with records already in it

[goslincm]

I'm viewing a table with 6,000 plus records. There is no unique key that was ever assigned. Ideally three of the fields in this table would make up a unique key but at this point I don't know the best way to normalize this table of information.

 

[dhookom]

Normalizing doesn't really have much to do with the primary key or lack of one. If you really need normalization assistance, you need to provide information about your fields and data.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[coachdan]

I would recommend making a copy of the db to do your normalizing with. Then maybe create a new set of the tables and call them yourTableNames_New. Make your changes to those tables - you can use an update query to populate the fields with data. That is an easy way to move data over one field at a time.

coachdan32

http://www.malehsbaseball.com