I am working on a project where I have 2 warehouses, each with it's own inventory and am trying to create a way to compare the inventory in each. When I get an order, I would like to know if I have the items on hand and which warehouse houses my goods.
At this time I have my small database...