Hi there. I have 2 questions which I think are related, and could do with some guidance on.

I have an editable number field in the table below (Quantity Shipped), and I would like to be able to only allow values to be entered that are between 1 (as the minimum) and the value of the Print Quantity column as the maximum. Not sure if this is possible with an editable table field?

As an alterative to the above, I am looking to create a calculated field. I am wanting to calculate Print Quantity  Quantity Shipped and display the answer in the Quantity Remaining column. The difficulty I am having is that the Quantity Shipped field is editable, and I am struggling with getting the edited value for the correct row into my calculation.
If anyone has any thoughts, it would be much appreciated
Many thanks
Adam