access 2000 booking system

[topspeed]

hi guys....can someone help me...?
i have too make a database that books vehicles into a garage and then with the information given reference parts only made for that vehicle, finally add all the parts required and print invoice!
I have 5 tables so far:
CUSTOMER(Customer ID(PK) first name last name address vehicle registration)
SERVICE RECORDS (Service recordID(PK)service date customer id registration number Product id Previous service date)
VEHICLES (Product ID(PK) manufacturer model customer id part number)
Parts (Partnumber(PK) part name unit price product id)

BOOKINGS( booking ID(PK) date customer id registation number product id service record id)


Is this correct..??

 

[randysmid]

Hi,
I would first like to recommend that you don't have spaces in any of the field names. It is very hard to read all the field elements in each of your tables. For instance, you should use names like this:
LastName
FirstName
ProductID
CustomerID
Why don't you use VIN number to keep track of each vehicle in your Vehicles table, instead of ProductID??? That way, if the current owner sells to someone else, and the new owner brings the vehicle in, then you will have a history of that particular vehicle, regardless of current owner. Make sense?

CustomerID should NOT be a part of the Vehicles table, nor should the PartNumber be a part of it. That is because many parts will fit many different vehicles. Because of this exact situation, you need to have another table that contains PartNumber and ProductID (which is really each individual vehicle). Make sense?

HTH,
Randy Smith
California Teachers Association

 

[topspeed]

thanks for help...am no on my way forward