1 Reply Latest reply on Dec 13, 2013 6:09 AM by cwiltgen86

    script for copying fields into other table


      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?