How do I fix this?

[whitjl143]

I have a table with Name, Date, Description fields. This table has 11,000
records in it. I now know that I need to have the Name and Date fields in a
table and the Description field in a separate table. Then I would use forms
and ID fields to link the information.

The following is an example of what is in the table:

Name Date Description
John Doe 3/27/05 Zone 1
John Doe 3/27/05 Zone 2
James Bond 3/27/05 Zone 5
James Bond 3/28/05 Zone 1

I don't know how to take the data and manipulate except by manually deleting
the duplicate names and dates and adding an autonumber field to get Table
one. And then manually entering the number to match the autonumber field in
the Description table. I am afraid that if I do this, I will mess up the
data and it won't be accurate anymore.

Any help out there?

Thanks!

 

[Jeff Boyce]

Jenn

First, consider renaming your fields -- I believe Access uses all three of
those words as "reserved". Continuing to refer to "Name" and "Date" will
only confuse both you and Access.

Why do you believe you need to keep YourDescription in a separate table?
From your example data, it may be that you need TWO additional tables (one
for valid Zones, and one for valid PersonZone combinations).

You can use Append queries to fill in records in new tables.