AnsweredAssumed Answered

Archiving records

Question asked by dsimonson on Oct 7, 2016
Latest reply on Oct 11, 2016 by dsimonson

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?

Thanks.

Outcomes