Hi all, I have two tables
Table 1(Snapshot): keep the name of items and the current number of items
Table 2 (Transaction): store all the transactions.
For example, I want to add 3 more quantity of Item A. I key in the form in Table 2. The number of the same items in Table 1 should be updated by 3. Can someone share with me how to work on this? It sounds simple but I can't do it T-T
LinkedIn
Twitter
