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!