script for copying fields into other table

Discussion created by terencetcm on Dec 13, 2013
Latest reply on Dec 13, 2013 by cwiltgen86

Hi there,


I am creating a shopping database, I have two tables: 1. shopping_list and 2. recipes. in #2 recipes fields: recipe_name, ingredients, amount, cost etc.


in #1 (shopping_list) fields of shop_ingredients, shop_amount, etc. So, I would like to add the ingredients from "recipes" into "shopping_list" and at the same time, check to avoid any duplicate ingredients in the "shopping_list".


Can anyone help me to start building this script?