Re: Append multiple records from a single record


DavidES (donotspam) wrote:
I have a table "Items" of orders for items such as gift certificates. I
transfer the gift certificate orders to another table "GC" which becomes the
log of gift certificate numbers and the unused balance of the certificate.
My problem is sometimes a customer orders two or more gift certificates and
I must manually duplicate that order in the "GC" table as many times as
needed so I can assign the correct gift certificate number to each
certificate and track the balance of each certificate.
Is there some way I can programatically do this?


yeah a UNION statement..

-Aaron

.