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

    script for copying fields into other table

    terencetcm

      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?

       

      Thanks,

      Terence