out of stock table relation

[abhi159]

i have to create two tables are wholesale and orders like in wholesale like i enter 5 iphones so in orders table only 5 iphones should be there like if someone order 3 iphone than other order 2 iphone now there is no ipone like now if someone order it show out of stock

[Sonam_Tiwari]

While placing order its better to just show the item's existing quantity which is in wholesale table and then what you can do is, once the order is completed, you can write a business rule to reduce the quantity by the number of device orders placed. Next time, it should point to the updated quantity while placing the order.

This is what I can think of roughly. 

For more clarity, it would be great if you can post few screenshots of fields present on these tables and form view.

[abhi159]

how i want idea 

[Dr Atul G- LNG]

Hi @abhi159 

.1. You need to set the total quantity

2. After order has been place , store that value in another field

3. Run BR where total quantity - Order quantity

4 Display in Portal (also it must be dynamic or put validation) user cant order more than the quantity.