Updating a table from other tables
I have 5 tables in my project done in Visual studio 2010 (VB). Tables A, B, C, and D. The fifth table, table E, should be updated by tables A, B, C, and D. These tables have there data types as currency. Every time tables A, B, C, and D are used, there is a need to update table E because table E gets all its data from tables A, B, C, and D.
How can I manage this? Database is mysql Express.