hi..may i know how the right design for inventory stock if there are transaction between branches.What i have think that every branch must have MasterStock for every item.I need to count every single item for every branch and also need to total every single item for all branches?I dont know how to design the table.

Example:

Branch A -------->Branch B--------> Branch C and so on.
Stock IN Stock Out

Please someone who have done this similar program before.I really need your help.Thanks