Linked databases

Hi. I was wondering if it would be possible to link databases in such a way that one database keeps stock of some items and the other is used for choosing (and using) an item from the stock and the stock would keep count of what’s left of that particular item?
I would e.g. have 10 units of one item and I would like to use one by picking through the other database and then the remaining units would then show 9.
Hope you can help.
Sent from my iPhone using Tapatalk
I would e.g. have 10 units of one item and I would like to use one by picking through the other database and then the remaining units would then show 9.
Hope you can help.
Sent from my iPhone using Tapatalk