Move records of 2 tables to 2 history tables

Discussion created by paulsondervan on Feb 4, 2017
Latest reply on Jun 8, 2017 by paulsondervan

At the beginning of a new year the records of 2 tables (PatientAfspraken en PatientAfsprakenDetails) have to be added to the history tables (HistoriePatientAfspraken en HistoriePatientAfsprakenDetails).

The relationship must be preserved.

After the records have been added to the History tables, the records in PatientAfspraken en PatientAfsprakenDetails.

What is the best way to do this?