I want to create a Database where someone can input a part number via a search box or similar and it will return a list of part numbers that will interchange with it. We sell parts that direct interchange with several other manufacturers. I want to have a search DB on my site where they can enter one of about 12 different part numbers from other manufacturers. It will then return a list of all direct interchange part numbers.

Best Software or webservice to use?

How to do it, Etc.

Thanks

George

and the database type and server side code that this will run on is?

otherwise the sql query will be something like;

SELECT alternateNoColumn from partsTable where MfrsPartNoColumn = [User Input Value];

If you know how to program in PHP and use MySQL for the database you can do it yourself. Do you know how to do that on your own? If so I can help you with any trouble shooting, otherwise it's actually quite a bit to explain if you don't already know how to program in PHP.

Would you be able to handle the major part of it? Here your query will be simplified. You should make your mind for either you want to hire someone or you want to code down your db at your own?