Searcing by dates
I have an odd problem. I have a table for auto parts. in the table the are 2 columns, FY (First year) and LY (last Year). Let's say you need an engine for a 1999 chevy Malibu LS.
The engine thst fits it will be FY=1997, LY=2000. How would you handle this as a search using a drop down with the year for your auto?