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?