Looking for a little guidance. I'm attempting to make a simple database in Access and have zero experience in DB design or creation. I'm attempting to make a small database for recipes to run from a tablet in our kitchen. My idea is to have the main form have photos of each dish in the database (it will not be many recipes until I get it up and running). When the user clicks on the photo a form will open with a photo of the dish selected, the recipe, and each kitchen item (bowls, utensils, pots/pans, etc) that will be needed to complete the dish.
I'm having some trouble setting up tables/queries to accomplish the last part.
My plan was to have a table with all of the kitchen tools listed in it with their photo and name. On each recipe in the recipe table, there would need to be some sort of field to designate which kitchen tools should be listed and a query to fetch that information from the tools table.
I'm not looking for anything except guidance, suggestions, etc. I'll hack away until I figure it out eventually, but figured if someone could point me in the right direction that would be helpful.