Closed

small vehicle service database - repost

This project was awarded to mtrangprogram for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
24
Project Description

I need a small database project, it will need to handle the following data
Part 1
VehicleID (autonumber)
Vehicle Reg No
Vehicle Make
Vehicle Model
Vehicle Type
Vehicle Other (just in case)

Part 2
OwnerID(autonumber)
OwnerLastName
OwnerFirstName
OwnerAddress1
OwnerAddress2
OwnerTown
OwnerCity
OwnerMphone
OwnerPhone


Part3
JobID(autonumber)
WorkDone
Parts Used
Vehicle Notes

Part4
PartsID
PartName
PartDesc
PartSupplier
PartCost
PartRetail price


Vehicle input form to fill Vehicle table
Owner details form, to fill the owner table
Parts Details form, to fill the parts table

I need a basic job or work order form, On entry of the Vehicle Reg Number in a combobox the rest of the vehicle details will fill vehicle data fields from the vehicleID table if the vehicle details are already stored, if not found then the option to add should be avaiable. Owner details will be be the same way with combobox showing lastname/firstname from owner table.

I must be able then be able to enter details of work done, probably as memo as this may well exceed 254 characters
when I enter parts used this will also be via a combobox pulling data from parts table.

Goes without saying that date and invoice number should also be stored

The above workorderform will fill another table which will have the owner ID, Vehicle ID workdone and partsID, with QTY used and unit price , this information will then be used to generate an invoice showing, Owner details, Vehicle details, Work done and all parts used and unit price of parts, this unit price must also be editable on the Job sheet without affecting the other data in the database.. so must not alter the price in the parts table.

PLEASE ONLY BID IF YOU ARE ABLE TO DO ALL OF THE ABOVE AND ADD A BIT OF INITIATIVE WHERE REQUIRED

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online