Question

[faca]

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:

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)?

[pbaldy]

If the master/child links of the subform control are on both the customer and car, it would automatically display the appropriate cars. Failing that you could filter a subform using those fields after they've both been selected.