Table Design in VB 2010
While using VS 2010 (VB),I have several tables in MS Access as the back-end. One table is storing data about product sales on daily basis, ie. Products A, B, C, D, E, F, G, H, etc. I need to create another table which will SUM up the total sales of each product, i.e. SUM of A, Sum of B, Sum of C etc. How do I manage this?Secondly, in this table with the SUM of each product, Money can be transferred from Product B to Product D or C, or A etc. How can I achieve this with both tables having changes in there total sum? i.e If money is transferred from Product B to Product C, Total(SUM) in B should REDUCED while SUM in Product C is being increased.
