How can I build the following relationship

edited 02/27/24 in Smartsheet Basics

I am a new ser to Smartsheet and want to figure out how to do the following:

I have built an inventory (very simple) to keep track of what we have in stock. However, I am not sure how to keep track of what is being sold. I want to create a sheet where I can input what is being sold, and have this number updated automatically in my inventory.

I am not sure how to create this, or the best way to go about this.

Any help is greatly appreciated.