Hello!
I have database (car repair) with 4 tables:
Costumer (Info about costumer and car)
Parts (PartID, PartNumber, PartName, Unit, SellingPrice, PurchasePrice, Store, TaxRate)
Service (ServiceID, CostumerID, Kilometers, DateOfService, Notes, Paid (Yes,No), PaymentType)
ServiceInfo (ServiceInfoID, ServiceID, PartID, Quantity)
Problem is that when i enter new price for part all previous services get auto-updated..
Example:
3 march -> price for motor oil is 80$
Service 1
Service 2
12 march -> price for motor oil increases to 89$
Service 3
Now if ill update price to 89$ also price in Service 1 and 2 will be updated to 89$ (it should stay 80$)
How could i fix this?
Thanks