Dear all!

I need your invaluable help!
I am working in a food distribution company and I must do urgently a database with all my suppliers; each supplier can deliver at least 5 items, but with different availability ( for example Supplier 1 can deliver oranges in march, April, may, tomatoes in Jan, Feb, Mar etc...and Supplier 2 can deliver oranges in Oct, Nov, dec, Tomatoes in June, July, August ...aso). AT the end, depending by current period selected (ex. June) and/or by item requested I need to extract the suppliers which fulfill the requests.

Being too many variables (one supplier can deliver many items in different periods) can you give me an idea / solution in order to design this database?

I am waiting for your feed-back asap - With great respect!