I'm relatively new to Access, and I'm still struggling my way through things. I'm trying to create a database that takes all of my assemblies and looks for commonalities in them. Here's what I'm wanting to do, going to a kitchen-based analogy:
I have all my recipes from a cookbook loaded into a database. I'm baking a cake and then would like to bake something else. What I want to do, based on what ingredients I have out on the counter top (eggs, flour, oil, etc...) is determine what recipe from my cookbook I can bake that takes most advantage of the items I already have out? Basically, since I'm baking a cake, cupcakes would make use of 80% of the ingredients I already have out.
Has anyone done anything like this?
Thanks.