What is a good design for Table:
1. Detail Stock. It is used for recording transaction history. It could be use for FIFO, LIFO and Average.
2. Total Stock. It is used for user interface thus need faster loading.
Those table should be sync every time change affect to Detail Stock Table.
Please help ?