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:
![image 1.jpg image 1.jpg](/t5/image/serverpage/image-id/29649i94DD9F6C79D07A02/image-size/large?v=v2&px=999)
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:
![image 3.jpg image 3.jpg](/t5/image/serverpage/image-id/29651i308F1430531F6591/image-size/large?v=v2&px=999)
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:
![image 2.jpg image 2.jpg](/t5/image/serverpage/image-id/29652i765784D53B11BABA/image-size/large?v=v2&px=999)
Thank you.