Copy Data from One table to another

[Jessica]

I have two tables one call address and the other one General. They have three
fields in common. First Name, Last Name, DOE and Birth Date, the address
table has all this data already enter i need the General table to have the
same data. Would it be best to put it in a query.

 

[pietlinden]

I have two tables one call address and the other one General. They have three
fields in common. First Name, Last Name, DOE and Birth Date, the address
table has all this data already enter i need the General table to have the
same data. Would it be best to put it in a query.

No, it would be best to keep address information in one table and link
the two tables together when you need data out of both of them. Then
when you query, you can get data out of either/both tables as
necessary.

 

[Beetle]

That data should exist in one - and only one - table. The only value
that should be stored in any related tables should be the key value,
i.e. MemberID (or whatever it is).

Why do you think you need to duplicate all the same data in another table?

 

[Cathy b.]

Along the same lines - I also have 2 tables in the same database that I need
to copy from one to the other - Table A was created really quick and dirty to
get something to put data into. Now that I've had a chance to do a better
database design I need to start tearing Table A down into separate tables.
I've created Table B which needs only two columns from Table A. The two
columns are the key in both tables. I will likewise want to start moving data
from Table A into other tables and eventually I will stop using Table A
completely.