Access Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2261962%22%20slang%3D%22en-US%22%3EAccess%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261962%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20rather%20comprehensive%20database%20to%20create%20and%20cost%20recipes.%20Realtionship%20table%20attached.%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20use%20part%20of%20a%20recipe%20within%20another%20recipe%20from%20the%20same%20table%20(%20TblRecipe)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%20I%20would%20need%20to%20use%20leftover%20mash%20(%20which%20is%20a%20recipe)%20in%20a%20soup%20which%20is%20a%20recipe.%3C%2FP%3E%3CP%3EI%20have%20created%20the%20form%20(%20also%20attached%20)%20using%20TblRecRec.%20however%20i%20cannot%20edit%20the%20table%20using%20the%20form.%20The%20filter%20work%20on%20data%20that%20I%20typed%20directly%20into%20the%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20any%20good%20with%20VBA.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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