old Table Normalised. Extracted data linked to old in a one to man

[Billp]

Hi,
I have an old table which I want to extracted some rows out of to create a
new table. The new table will be linked to the old master in a one to many
relationship.
The old table was a customer database (one) with one delievery address.
The new table will house the addresses (many).

I want to append the data to the new table.
I want the new table to be linked via the CustmerID which is common.
I have created the relationship of one to many on the filed.
I want to append the data to the new table.

In the form the customer will have a subform which is the Delivery address
in a master to child.
How do I take the data so that i can create a one to many using the old data
but be able to add data - make sense?

Regards

 

[Arvin Meyer MVP]

MAKE SURE THAT YOU MAKE A COPY FIRST

Append the data from the old to the new, forget any fields that don't
participate in the many side. Now once you are sure that the data has
appended correctly, delete the fields which house the many-side data from
the old table.

Now run a Select Distinct query on the old table and use that for a make
table. That should get rid of most of the duplicates. Now run a duplicates
query from the query wizard to find any remaining duplicates and delete the
rows you don't need.

MAKE SURE THAT YOU MAKE A COPY FIRST

 

[Piet Linden]

Hi,
I have an old table which I want to extracted some rows out of to create a
new table. The new table will be linked to the old master in a one to many
relationship.
The old table was a customer database (one) with one delievery address.
The new table will house the addresses  (many).

I want to append the data to the new table.
I want the new table to be linked via the CustmerID which is common.
I have created the relationship of one to many on the filed.
I want to append the data to the new table.

In the form the customer will have a subform which is the Delivery address
in a master to child.
How do I take the data so that i can create a one to many using the old data
but be able to add data - make sense?

Regards

The relationships and the forms are irrelevant to the question.
An append query.