Move data from Primary table to a One to Many Table

[Mary M]

I have a DB which has contact info stored in a One-to-Many table. The main
Table has some additional contact info which I would like stored in the
One-to-Many table. Data is seperated by fields such as Name, HomePhone and
WorkPhone. These fields exist in the One-to-Many table as well. Is there a
way to run a Query that would accomplish this? If so how?

Many thanks in advance.

 

[CJ]

I have a DB which has contact info stored in a One-to-Many table. The main
Table has some additional contact info which I would like stored in the
One-to-Many table. Data is seperated by fields such as Name, HomePhone and
WorkPhone. These fields exist in the One-to-Many table as well. Is there a
way to run a Query that would accomplish this? If so how?

Many thanks in advance.

We are going to need some clarification Mary. I'm guessing that your "One to
Many" table is on the One side of the relationship and your "Main" table is
on the Many side of the relationship?!?

It's not clear what you are trying to accomplish. Are trying to combine
everything into 1 table?

Please list ALL of the fields that you have in each table and we might be
able to help you out.


CJ

 

[John W. Vinson]

I have a DB which has contact info stored in a One-to-Many table. The main
Table has some additional contact info which I would like stored in the
One-to-Many table. Data is seperated by fields such as Name, HomePhone and
WorkPhone. These fields exist in the One-to-Many table as well. Is there a
way to run a Query that would accomplish this? If so how?

Many thanks in advance.

Why would you WANT to store the Name, HomePhone and WorkPhone information
redundantly in a second table?

What is each table's Primary Key? How are the tables related? Do you want to
*copy* the fields into both tables (almost surely a Very Bad Idea), or *move*
it - if so, from where to where?

John W. Vinson [MVP]