Has anybody heard of this type of database
----My business description
In my shop i have stock items
and i have a few vans where i have my techs fix centain things
when my techs need something they come to me and ask for them
basically i want a database that would allow me to see the inventory of the vans and the inventory of the shop
Shop:
8 wheels ( example)
if van 1 asked for 2 wheels i want to be able to move wheels from the shop to the van in database form. so that next time when he asked for wheels i can see that he should have 2 wheels already in stock in his van