2 Replies Latest reply on Jun 8, 2017 12:30 AM by paulsondervan

    Move records of 2 tables to 2 history tables

    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?

       

      MoveTablesToHistory.png