Dual Tables - Update

• If you create separate historical tables
• You have to keep them updated
• Various approaches (new invoice → historical transaction)
• Users need to be aware of design
• Prevent users from querying the wrong data