Figure 1 Link the Tables. The sample database in Access includes many-to-many links between the Recipe table and the Ingredient table using the Recipe Ingredients table. I have simplified this design with an Ingred table to make the code easier to follow in the Recipe database.