Search function in Microsoft Access

[jess82]

Hi everyone,

Thanks for taking the time to read this.

I will firstly give you the low down on the business that I am doing the database for. It is a Car Restoration Business, where we deal with vintage/classic/muscle cars and restore them to the former glory.

I do not know Microsoft Access very well, I have attached a file with what I think is a databae I could be wrong. The main function of this database is to search for suppliers for a specific car part for a specific car.

So if I want to find a doorhandle for a 1970 Ford Mustang, I need the suppliers pertaining to those criterias to come up.

How do I get this to happen?

Thankyou for your help

Jess

 

[neileg]

Needs work!

The vehicle type shouldn't be in the supplier table. This will restrict the supplier to only one vehicle type. However, I assume that there will be more than one supplier for any given part, but your structure only allows for one supplier.

In the parts table you should be holding the PartID and the VehicleTypeID, not the part name and vehicle type name.

I suspect that some parts will relate to more than one vehicle type. Your structure doesn't allow for this.

Is this an assignment or a real world application?