How do I move records from one table to another with different fi.

M

myinsuranceagent

I have two tables with common and unique field names. I need to move the
common data between the two tables and keep the unique data. I can do this
manually of course but how can I let Acess do it for me?
 
J

Jeff Boyce

In a well-normalized relational database, there's rarely a need to have
duplicate data in two tables. If you describe a bit more about why you feel
it's necessary to "move data between tables", the 'group may be able to
offer alternative approaches.

It's absolutely possible to do, I'm just asking to see if it is also a good
idea to do...
 
Top