Hi everyone,

I would be grateful to everyone who offers solutions

I have two linked tables:

Problem 1  ✅ Resolved

I need a formula for the "Status" column that will display such statuses:

Problem 2

When I add a new record to the "Sales" table, I need to make sure that the product does not appear in the list if the entire quantity is sold:

Problem 3

When I select the quantity of products in the "Sales" table, I need to make it impossible to select more than the quantity in "Purchase" table:

Thank you.