Design Suggestions Please

[dfwcomputer]

think i should be posting here as it is more of a design question,

i would like a list of customers who have bought machines off me, the machine they bought, the serial number e.t.c, parts used in a service on this machine.This way i can click a button to display a list of items needed for the service of a machine.I also want to setup next service date and eventually have a to do list that i check every day to see who's machine needs servicing.

see what yous ythink?

tblCustomer
CustomerID
CustomerName
Address
State
PostCode
Phone
Mobile
Comments

tblEmployee
EmployeeID
EmployeeName

tblParts
PartsID
PartNumber
PartDescription

tblMachine
MachineID
MakeAndModel
AirCleanerIn
AirCleanerOut
Blades
BladeBolts
BladeNuts
DriveBelts
FuelPrimary
FuelSecondary
HydraulicFilter
OilFilter

tblService
ServiceID
CustomerID
EmployeeID
ServiceDate
NextService

tblServiceParts
ServicePartsID
ServiceID
PartID
Quantity

tblServiceLabour
ServiceLabourID
ServiceID
EmployeeID
Hours
Comments

tblCustomerMachine
CustomerMachineID
CustomerID
MachineID
PurchaseDate
MakeAndModel
WorkOrder
SerialNumber
EngineNumber
RegoNumber

AirCleaner through to OilFilter in the tblMachine would be lookups to tblParts

Am i on the right track

Thanks in advance

Dean

 

[dfwcomputer]

here is a sample guys see what yous think