extracting records from many tables

sheederj

Registered User.
Local time
Today, 09:32
Joined
Jul 26, 2001
Messages
27
Hi, I have a database of patients in a prenatal care clinic. What i would like to be able to do is keep "active" patients in one database, and when they are done (have their baby) they move to a permanent database. The reason is, that my database is on a network being access from two different locations and if stored on the server at one is too slow from the other. The problem is that records exist in about 25 tables. So anyone know how I could get access to do this? I have a field on my main patient table that is checked active so when we generate reports it does so only on actives so i'd like a way to move all their data to the matching table in the permanent file. I did think about linking the databases and having only actives show up on the clinic side, but haven't tried it yet. Thanks for your help!
 
How about a "Make Table" query? based off of the patient "Active" ressults and then for new additions to the new table an "Append" query.
I know that this method will copy the records to the new table but I don't think they will "remove" them from the main table.

Just an idea
 
not quite...

That would work except that I have to extract individual records from about 25 different tables and put them into the same 25 different tables in the other "archive" database.
Thanks,
j
 
25 tables sounds like a lot for this type of application.

Since you have a status field available - birth date - you can use that to limit the records returned.

Where BirthDate Is null; --- will return all the "active" records.

Unless you have hundreds of thousands of records, you probably will find it more annoying to split the data into an archive - especially with 25 active tables!
 

Users who are viewing this thread

Back
Top Bottom