Inventory template: Can I make a form that updates two different tables?

[CentralOrdering]

I am using the inventory template to manage some inventory. We have a central warehouse that holds our main stock and then individual stores that will order from that stock. It would be awesome if we could create a view that allows someone to enter an order for multiple items at once and have that entry add inventory to the store thats ordering it and subtract from the inventory of the central warehouse. Do folks know if that would be possible and if so what that might look like in the big picture?

Thanks in advance!