July 16, 200619 yr 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
July 16, 200619 yr 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.
July 16, 200619 yr 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
Create an account or sign in to comment