Archive records and Re-Activate

[Amanco]

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,

 

[Steve Martino]

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.

 

[Amanco]

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