Apologies for the unclear topic. I have a recipe database, where I have tables for • recipes • ingredients • recipe-ingredient junction, where I store data of e.g. amounts in recipes I just realised i will need to easily make different versions of ba...

I’m working on a recipe production database. I will have a table for all available ingredients, and another table with recipes that uses ingredients. When writing a recipe, i have a linked field where the author can pick ingredients in the recipe tab...