adding records to a table

[johnrh]

Table A contains a list of names. I need to copy some of these records from Table A into a separate Table B every week. If there a way of doing this vey quickly and simply?

Thanks

Dave

[dkemme]

How about a find for Table A of the records than need to be copied, gotolayout based upon Table B, import records from Table A.

But... I wonder if you need to rethink your design. How about a Table C that has all the names and Table A and B related back to the names by a Table C_ID.

[Søren Dyhr]

I second that, copying data around isn't healthy, an aim with relational databases is to store everything in just one place and then pull it on demand by knowing it's location via realtional keys.

--sd