• you can create an archive table that keeps only the previous version data, it's good to have the history information in other table. Also it depends how your business requirement need to follow up .

    like - how many versions do you need to keep ? how many revert back you would have to allow ?

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm: