Send Record to new database

[Linda RQ]

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

 

[Rick B]

I would not recommend deleting or moving records. Personally, I would
include a "discharged date". In all of my forms, reports and queries that
only want to see active patients, I'd exclude records with an entry in that
field.

You could then build forms, reports, and queries that pulled discharged
data.

I would not allow my users to delete the records.

To convert this to a normalized database, you'd need quite a few tables:

TblRooms - Alist of available rooms and beds (this might end up being two
tables)
TblPatients - One record per person
TblAdmissions - One record for visit. Would relate as a one-to-many to
TblPatients. Would relate to TblRooms.
TblTherapy - Would relate to the Admissions table. One record per therapy.
Might have multiple records per admission.
TblMeds - One record per "order" per admission?

etc.

I'm pretty sure you'd need several tables in addition to the ones above.