Hi,
I have a table with different recipes and now I want to copy old recipes to create new recipes, this will be useful if many ingredients are similar in different recipes.
tblRecipes
recipeID
ingredientID
qty
So lets say I want to select all rows where recipeID = 24 and update table with those rows but change recipeID to, lets say 25.