Gift Certificates
Ray,
Thank you. I'm thinking you could select sum on the orders table with the key of the orderid and product id and subtract the total amount in the orders table (making sure it doesn't exceed 0) from the current order.
Doesn't seem too bad.
Terry