Auto Repair Pages

For Auto Repair Database

All pages use the p478870b_RepairShop database. The primary keys do not auto-increment, except in the Log table.
The database is set up to handle multiple repairs per job and multiple parts per repair.
However, this feature has not been implemented in the "Add a Job" or "Add a Repair" pages.
Those pages only add one repair or part, respectively.
The estimate field is currently required for to add a job, which is not ideal, so I imagine the "estimate" to be a baseline cost to select.

Add a customer
Update a Customer's information
Add a car
Update a Car's information
Add an Estimate
Add a Job
Add a Mechanic
Add a Repair
Add a Part
Display Jobs
Display Estimates
Display Repairs
Display Parts
Display Cars
Display Customers
Display Mechanics

This report displays Jobs with Customer Name, Car info, Repair info and Job info.
It is based on the RepairJob table and not all jobs are currently linked.

Display Job info Report

Home