Linked table

[Sara]

I am pulling information from a linked table SQL Database
into access 97. This table will be continually
changing. How do I select a record and add it to another
table?

Thank-you in advance!

 

[Jeff Boyce]

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?

 

[Sara]

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

 

[Jeff Boyce]

Sara

Just because a resident moves out, doesn't mean the SQL database necessarily
deletes that resident. If I were designing a "residency" database, I would
want to keep information on former residents. You may wish to pursue this a
little further, as you will run into potential synchronization issues as
soon as you begin storing more than one copy of the same info.