Need a transitiong tool

[CrakD]

I have 2 Databases. A Referral Database, an Active Patient Database. How it works is..the patients are referred by doctors, therapists, etc. The information like date of birth, address, phone number etc. is input into the database. Then when the patient gets evaluated (up to SEVERAL weeks after the REFERRAL has been made) they become active patients and are therefore input into the Active Patient Database, where some more information is added like the treating diagnosis, Therapist, date of discharge etc. Maybe my structure is wrong..having two seperate databases. If that's the case I'd love suggestions. But..I'd really like to have a list box that populates with ONLY the referrals that need to be TRANSITIONED to the Active patient database. And..then..maybe have a little drag and drop kind of thing...like the frmsmp00 microsoft gives....so that it populates the fields. And then have the transitioned patients greyed out in the Referral DB so that 1) User knows that they have been transitioned, 2) Integrity is maintained. I have medium skills in VB but..I'm pretty sure given enough time i might be able to figure something pretty complex out.

Any help is appreciated

 

[OnTheFly]

My suggestion would be to have one table for all the patient basic information (Name, Address, DOB, etc.) with a unique ID (PatientID) for each patient and a Status field where you would store something like 'R' for Referrals and 'A' for Active Patient. That way your referral form could be limited to those patients with an 'R' status and to change them to an Active Patient you would simply change their status.

The additional information on Active Patients would then be stored in another table with the PatientID as the link.



Hope this helps.

OnTheFly

 

[Craig0201]

I would suggest the following.

Hire a professional to do the job or even better, find a tool off the shelf. Patient records are too sensitive and too important to be played around with. Imagine how much you could be sued for if something doesn't work that causes the patient to come to harm. Hence buy it from someone that has large public liability insurance.

Sorry if this does not answer the question directly but this is by far the best advice I can offer.