Hi Everyone,

Acess 2000.
We have a database that has been used to enter patients, room, treatments
they are on etc...This is a flat database even though patients can have
multiple treatments.  Suffice it to say it works well for what it's used for
but I would like to keep track of the records they delete.  When a patient
goes home, the record is deleted by using a delete record button.  Is there
any way to have that record sent to another database at the same time the
record is deleted without having to know how to write code?  Eventually I
would like to make a database that is relational for this purpose.  Does
anyone have something that they would be willing to share so I an see how it
was designed?  Here are all the fields we keep track of at this point.

RM#, BD#, ADM NUMBER, LAST NAME, FIRST NAME, THERAPY, MDI EVAL,  MEDS,
FREQUENCY, PULSE OX, VENT, ORDER DATE, OrderTime, TAG DATE, INIT,  COMMENTS,
LAST_CHANGE, ISOLATION, START DATE,  VENT_NO, ysnTDP

Thanks,

Linda