terencetcm

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?

 

Thanks,

Terence

Outcomes