Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Append records from other table
peace!!!!
i would like to append all the products into the purchased table when i selected a category(product table).
for example:
joe selected a category; fruits. then all the fruits from the product table under the selected category shall append to the purchased table.and the purchase table will look like this(assuming that i already input the quantity and price or i already purchased)
>>>purc_id -- name --- prod_id --- prod_name --- quantity --- price &&fieldnames
>>>1001 ------joe--------p101--------apple--------3 pcs-------$10 &&records
>>>1001-------joe--------p102--------mango--------2 pcs-------$12
>>>1001-------joe--------p103--------orange-------2 pcs-------$10
is it possible and how?
thanx!!!
>>>>>>product table
category:
product_id:
product_name:
>>>>>purchased table
purc_id:
name:
prod_id:
prod_name:
quantity:
price:
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement