Updating quantity?

Need help Database
1

Hi, I’m trying to build an inventory tracker app (management) This is my data

Quote

  • [ ] Customer - Customer
  • [ ] Number
  • [ ] Price
  • [ ] Quote-date - Date
  • [ ] Due date - Date
  • [ ] Paid-status - Yes/no with no default
  • [ ] Paid-date
  • [ ] Items - List of products/services
  • [ ] PDF - File

Product/service

  • [ ] Name
  • [ ] Description
  • [ ] Quantity - Number
  • [ ] Rate - Number
  • [ ] Total - Number

My question is : How can I update my material’s quantity when i generate my quote ?

2

So are you saying, after you generate a quote you want to subtract that quote’s quantity from the quantity of the product?

3

Yes I would like to subtract the product quantity on my product page

4

Yes exactly

5

After the quote is created, you can do a Make a Change to the product in that quote, and the quantity would be the quantity of the product - the number in the order.

1 Like