Access recipe costing and inventory database - repost

I need a database for calculating recipe costings. TABLES As I see it this would consist of; Table 1: Suppliers - Name Table 2: Ingredient category - category Table 3: Units - Units Table 4: menu sections - sections Table 5: Ingredients: Ingredient name, supplier name (drop down from table 1) Ingredient category (drop down from table2), unit (drop down from table 3) cost per unit Table 6: recipes - For the recipe costings themselves I need to be able to add multiple ingredients, anything from 3 to 30 so it needs to be flexible. Also, I need to be able to add other recipes as ingredients. This could be a separate section but again I need a lot of flexibility in how many I can add. Ideally the form would start off with 1 drop down for ingredients and 1 for recipe ingredients with a button or something to add more as needed, I don't know if that's possible though. The info I need on the recipe table is; name menu section(drop down table 4) recipe yield recipe yield unit (drop down from table 3) ingredients (multiple drop downs table 5 bringing over unit and cost per unit) Plus field for inputting quantity recipe ingredients (multiple drop downs of recipes ordered by section/alphabetic bringing over unit and cost per unit) Plus field for inputting quantity Recipe cost: each ingredient and recipe ingredient quantity multiplied by the cost, all added together and divided by the yield amount. Table 7: Dishes Basically a copy of table 6, excluding the yield and yield unit and adding a selling price field. REPORTS 1. I will need a printable report of all ingredients, ordered by supplier then alphabetical with current prices and an empty filed next to each for price checking. 2. A report listing all recipes from table 7 detailing name, recipe cost, selling price and a calculated field for each recipe showing '1-(recipeCost/sellingPrice) expressed as a percentage to 2 decimal points. FORMS I would want a auto start dashboard consisting of; Dash 1 - report 1, report 2, add items subform, edit items subform, other subform Add items subform: add ingredient (new record form for table 5), add recipe (new record form for table 6) add dish (new record form for table 7) Edit items subform: edit ingredient (new record form for table 5), edit recipe (new record form for table 6) edit dish (new record form for table 7) If it is possible some way of searching for a particular item in the edit forms would be very useful. Other subform; links to edit form for the first 4 tables