I am making a database of stock control that has three tables; Sales, Product and purchases. everything is going well but may you help me with this.....
May you support me on how can i make a sales form that has fields like sales_ID, Item, qty, Price_@ and total. note Total is a calculated field. what i want is before someone does sales he needs to know what he has on that product.
How can i put this two things together?
May you support me on how can i make a sales form that has fields like sales_ID, Item, qty, Price_@ and total. note Total is a calculated field. what i want is before someone does sales he needs to know what he has on that product.
How can i put this two things together?