A LITTLE BIT OF HELP NEEDED
I am new to FP. But have created a program to maintain my inventory.
All Items have a quantity entered when purchased.
My quantity field is tied to a value field so that if I have 2 items it multiplies the cost to give me a total value.
I am fine until here.
I am trying to create a form that will allow me to enter sales and subtract the quantity of the item sold so that my original item table keeps up to date.
I have created a table for sales where as i enter the item sold a portal will fill in the item description and sale price. Running smoothly until here.
When I enter quantity sold I need something to take it off original quantity.