TVReplay99
Registered User.
- Local time
- Today, 00:37
- Joined
- Jan 2, 2002
- Messages
- 29
Udate new Price from Order
I am creating a fairly simple order and receiving DB. Before I begin creatind the order forms, I need to get my mind around one area. How do I update the Cost & SellPrice Field in my Stock Table from the order form when there is a change?
Ex: Hammer current Cost is $7.00
Sell hammer @$7.70 with 10% mark up(mark up field is in stock Table)
Order for Hamer now Costs $8
How do I write that to the Stock table as new Cost & Sell price? Or If I save the Cost and the Markup % should I even save the Sell Price?
Any advice or redirection in my thinking would be helpful.
Thanks to all.
Brian
I am creating a fairly simple order and receiving DB. Before I begin creatind the order forms, I need to get my mind around one area. How do I update the Cost & SellPrice Field in my Stock Table from the order form when there is a change?
Ex: Hammer current Cost is $7.00
Sell hammer @$7.70 with 10% mark up(mark up field is in stock Table)
Order for Hamer now Costs $8
How do I write that to the Stock table as new Cost & Sell price? Or If I save the Cost and the Markup % should I even save the Sell Price?
Any advice or redirection in my thinking would be helpful.
Thanks to all.
Brian