Yes, what I’m trying to do is very similar. I’ve integrated 3 tables into the db.
This table has all the make, model, year info and all vehicle attributes (drivetype, engine, trans, etc) related to the parts we carry.
How I’ve done the MMY search is based on this applications table, so there should be no deadends if we don’t carry anything for your car. Currently our data is in Access, so I have imported a sample into MySQL for testing. We have over 100,000 different part/vehicle combinations with about 4000 parts, so I’m leary about dumping the whole thing in at this time.
The “garage” idea is good. Similar to Napaonline and SummitRacing’s sites, but it is very handy that the site already knows your vehicle(s) when you get there.
What I “think” I need to do is have the MMY dropdowns initiate the search of “my” tables, then feed the results back to magento as any other search result. Now how I get there is my biggest problem. I’ve gone through some tutorials for adding custom modules without much success yet. I am still trying to get my arms around how it all works together. I would be happy to help however I can. Is there some IM or PM on this board so as to not tie up the forum? Thanks.