5 Replies Latest reply on Aug 3, 2015 11:34 AM by erolst

    Monthly updates, keeping prior month's data intact

    jlloyd

      I've searched for ways to achieve what I need to do, to no avail.  We have a database that tracks certain loan information in a "loan table" with several tables related to the loan table for analysis purposes.  Each month, we copy the database file before importing updated data for the current month so that all of prior month's data, related data, complex calculations, etc., stays intact.  I hope I explained this well enough!  Is there a "best practice" way of keeping all of this data in one database?  I don't want to continue copying the database every month as that seems as far from "best practice" and efficient as you can get and I just can't seem to wrap my head around a solution.  Thanks in advance for any suggestions!