• I think you might need to provide more information on your design.

    You could still use Carolyn's version concept, add a version to both tables, copy the data on edit to a new row. Or just update the related rows.