I want an *Access 2000* database where I can maintain a list of Meals, a list of ingredients and then assign ingredients to particular meals.
I then want to 2 reports:
[login to view URL] that shows the most used ingredients (most at top of list, down to least used at bottom).
[login to view URL] that shows the me the meals that have the highest ingredient re-use.(The meal at the top of the list should have the most ingredients that are most used.)
I only want to store :
* The Name of the Meal.
* A description of the ingredient.
The data-entry form should have a drop-down list of meals that I can add to. Underneath that should be the list of ingredients in that meal. On the right hand side should be the list of all the available ingredients. There should also be 'add ingredient to meal' and 'remove ingredient from meal' buttons. Please keep it simple.
## Deliverables
Access MDB file for Access 2000 only! (Full source code of course) All rights.
## Platform
This will run on 32bit windows version(s). In Access 2000.