goldencode

Dynamic Inventroy

Discussion created by goldencode on Jun 6, 2017
Latest reply on Jun 15, 2017 by philmodjunk

Hello everyone,

 

I am using the Invoices Starter Solution that is provided by Filemaker Pro 15 Advanced

 

In the table Products, each product has a quantity, now lets assume that i'm selling Mobiles and the quantity i have is 10 Mobiles, and because i'm lucky a customer wanted to buy 4 Mobiles, i'v created an invoice for him and the remaining Mobiles in my inventory are 6.

 

The question is, how am i supposed to create a Field (Remaining Quantity) in the table Products that will change according to the sold quantity? In other words i want to track the remaining quantity, i have been trying to reach out a solution the past couple days with no luck, my brain stopped working, therefore i'm here to get your assistance,

 

Please help, and thank you so much for your valuable time.

Outcomes