The database links an apartment database to the health
club database.

The apartment info is pulled an used for the contract in
the health club. The SQL table is dynamic in that the
residents move in and out. We want to keep a copy
certain records from the apartment datbase that will
eventually expire for archiving purposes in the health
club database. I only need 4 records from the SQL
database.
Thanks!
Sara
-----Original Message-----
Sara

If you already have the information in the SQL database,
why do you need to
"add it to another table"? (i.e., what business need are
you satisfying?).

Are you considering saving a copy in the SQL database or
in an Access
database?

--
More info, please ...

Jeff Boyce
Access MVP

.