I am currently working for a company and they need to me to create a database of all of their products along with the information relating to those products, so that i can then go into the database with a clients specifications and the resulting products which fit their specifications would be highlighted and filtered out. Once choosing a primary component such as a pump it is then wanted that a list of say engines/tranmissions/valves which can relate to that particular pump would then be displayed. Each component can then be chosen or ticked to create a final quote.
I dont know how complex this would be but i know exactly what they want just not how to do it, any help would be greately appreciated, and if you need more info i can try my best to explain.
thanks