My solution has two main tables relating to patient data - the Patients table and the Anesthetics table. Patients may have more than one anesthetic record.
Each of these main tables has a number of subsidiary (child) tables, related by either id_Patient or id_Anesthetic. For example, Anesthetics has over 20 child tables, each containing data relating to one anesthetic.
Here is my question:
What is the best way to archive these records? I would like to simply perform a Find on a field on the main table that would be marked “archive”, and then export them to a separate Filemaker file. But with so many child tables and so many fields, how is that possible without elaborate loops to copy all of the data from each record?