Creating tables dynamically in FileMaker isn't really practical. While there are ways that a script can create the table and import data into it, no currently existing layouts, scripts, etc. can access the data in this new table until a person with full access then makes additional design changes to the file.
Instead, all biographical records for all patients should be stored in the same table, but with a PatientID field that uniquely identifies each patient. Likewise a patient status table can record the patient status for all patients and for all their visits to the hospital, but other fields in the same record allow you to match the correct status record with the correct patient and visit to the hospital.
Thanks for the response. All of the biographical information for all patients is on one table. Likewise, I have a related table with a patient's ID # and their transplant status. However, I am wondering how I can relate patients with "transplant complete" to a table that only displays information for patients who have had a transplant and all the information that is necessary for someone who has had a transplant, since that information will not be needed for patients who get rejected for transplant.
Do you know if I will need to write a script to somehow only display patients with a certain status or am I digging too much into this and there is an easier way to relate this information?
Thanks again for your help.
Use this relationship:
Patients::PatientID = TransplantStatus::PatientID
If the patient is accepted for transplant, create a related record in TransplantStatus. If they are rejected, do not create the related record.
Great - Thanks again!