Searcing by dates

[Mushroom-Graphics]

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?

hanks

[Ray Borduin]

Use the list for two comparisons in the DataAssist Search wizard and have the four digit year as the option value in the list.

FY <= ListValue
LY >= ListValue