Hello!
I'm designing a database for my mechanic.
Problem is that currently he has all the information stored in notebook. It's painful when he needs to search trough notebook to get to the service that he done for particular car so that's why i am going to create ms access app for him.
Currently i have the problem with how to connect these tables:
Code:
tblParts:
PartID
PartNumber
PartName
Unit
PurchasePrice
SellingPrice
NetPrice
TaxRate
DateOfEntry
Code:
tblDeliveryNoteParts:
DeliveryNotePartsID
DeliveryNoteID
PartID
Quantity
PurchasePrice
Code:
tblDeliveryNote:
DeliveryNoteID
DeliveryNoteNumber
DateOfPurchase
Store
Delivery (Yes/No)
Every part that he needs for current service on car is purchased from a store (vendor) for certain price.
Each purchase like that has a delivery note (number of delivery note, date of purchase, delivery or pickup, quantity, purchase price for each part, store (vendor)).
What he wants is to have a history of purchase price and under which delivery note it was purchased for each a part.
Are my tables even correct or would anyone of you do it other way and how?
Thanks