Hello!
I have car mechanic database which i would like to upgrade too look similar to this workorder database:
Attachment 36449
My current look:
Example how my service form looks like ->
(it's in slovenian language posted pic just to show off how it looks like now)
Attachment 36450
Tables that i have:
Code:
Customer:
CustomerID
CompanyName
FirstName
LastName
Address
PostalCodeAndCity
Contact
Email
Vehicle:
VehicleID
CustomerID
Make
Model
VehicleType
Year
Transmission
FuelType
EngineType
EngineCapacity
RegistrationNumber
VIN
Service:
ServiceID
VehicleID
DateOfService
Kilometers
Paid (yes/no)
PaymentType
ProFormaInvoice (yes/no)
Notes
Parts:
PartID
DeliveryNoteNumber
Number
Code
Name
Unit
SellingPrice
PurchasePrice
NetPrice
Store
TaxRate (default 22%)
ServiceParts:
ServicePartsID
ServiceID
PartID
SellingPrice (i need that to store price in specified service beacuse prices for parts are changed every now and then (without this all previous service parts get new price)
Quantity
Notes
How can i make this form where i can choose customer and than car for which i can see past services and that would look like work order form on first image)?