Access Tables

Copper Contributor

I have created a rather comprehensive database to create and cost recipes. Realtionship table attached.

I need to be able to use part of a recipe within another recipe from the same table ( TblRecipe)

 

for example I would need to use leftover mash ( which is a recipe) in a soup which is a recipe.

I have created the form ( also attached ) using TblRecRec. however i cannot edit the table using the form. The filter work on data that I typed directly into the table.

 

Not any good with VBA.  

0 Replies