Tracking Inventory In & Out Across Several Buildings

Hello all,

I’ve been fiddling with the Inventory Tracking template to see if Airtable will serve our needs and could use a little guidance. We distribute food to a number of food pantries and keep a monthly inventory for all of them, tracking what is transferred into and what is transferred out/distributed from each inventory, along with the current inventory levels.

Hopefully that makes a glimmer of sense. Is there a way to accomplish this without setting up a separate base for each pantry and entering in purchase/sales orders into each one?

Many thanks!