Jump to content

Archive records and Re-Activate


Recommended Posts

  • Newbies

Hello,

I am new to filemaker and using filemaker advanced pro 18.

 

Im building a database for my patients who are admitted to the hospital.

 

I would like help please with the following:

1) when I discharge the patient, the patient’s data are “archived” and not shown on the report.

 

However, when the patient gets readmitted to the hospital, I would like to:

1) add patient by the hospital chart number

2) if patient is in the archive list, then activate and use the old data but under a new encounter to the hospital.

 

whats the best way of doing this?

 

Thank you for your help,

 

Link to post
Share on other sites

Probably not the way you are doing it.  I would think you would need a table for Admissions, which is a specific span of time for a specific admission, with Start Date and Discharge Date.

When creating a new Admission, it could be scripted to put the patients name in from existing patients or create a new patient record.  

A portal can show all the related previous records.

Keep in mind, all the patients history is important and may not come just from your hospital admissions.  Procedures and care can come from other hospitals, clinics, urgent cares and doctors offices-all which need to be in a patients history.

 

Link to post
Share on other sites
  • 2 weeks later...
  • Newbies

Thank you Steve,

Quote

Probably not the way you are doing it.  I would think you would need a table for Admissions, which is a specific span of time for a specific admission, with Start Date and Discharge Date.

I have done what you suggested with a table separate for admissions with a date of admission and date of discharge. I attach my relationships.

Quote

When creating a new Admission, it could be scripted to put the patients name in from existing patients or create a new patient record. 

Okay, instead of the patient's name, I am going to use their unique chart number or National ID number to search for the patient and then add as new admission. Exactly as you suggested, I would like everything in their past history to be duplicated but under a new admission, so when I edit the information, It will not affect the information in their old admission encounter.

Any pointers please on how to script this?

Also if you have any suggestions to my relationships, feel free to advise me.

 

Thank you

 

Relationship.PNG

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.