I am quite new to databases. I am creating a products datbase, where I have a table for products and table of ingredients. Then I have third table for product recipes with the following fields:
I need to create a form, where I can select a product from a listbox. Then I would need to specify its ingredients and their quantities and the measurement unit of each ingredient. There may be 1-50 different ingredients for each product.
I don’t understand how can I create such a form, where I can add ingredient lines. Is it possible to for instance have a button: “Add ingredient”, clicking of which would add a new ingredient entry line? Or what is the best way to accomplish this?