Re: Need filtered Drop down list to show options based on date entered in multiple fields

Awesome thanks...I will play with this.  My challenge is that our database is old and already has many records set up the way I show in my example.  
> I will set up the tables as you recommended and see if there will be some way of changing how things are done now, with this new method of handling Vendors.
> truly appreciate your prompt feedback - now I got some work to do ;-)