How to create entry form for many-to-many table in recipe DB

[Pawtang]

I've tried so many different ways to do this and I can't find a good way to accomplish this.

My thought is to use the many-to-many intermediary table to relate one product to many ingredients, each with their own properties... Since various products can have the same ingredients.

I have no idea how to handle the form creation for this scenario! I want to have a form where you can create a new product or pull up an existing product, then have a continuous subform where you can add a list of ingredients and quantities of ingredients related to that product. How would I start this?

[davegri]

Have a look at this DB. It's for a cupcake bakery. Enter new recipes, Create batches, compute costs, unit measurement conversions, etc.

CupcakeDB-davegri-V01.zip

[Pawtang]

Have a look at this DB. It's for a cupcake bakery. Enter new recipes, Create batches, compute costs, unit measurement conversions, etc.

Its adorable too. Thank you!

[davegri]

And thank you! The adorable custom color scheme created and applied here:

Theme Manager for Forms (accessforums.net)