The view is really just used to concatinate the product and coupon ID from the couponproducts table.
This is because our delete from database server behavior asks for the key field to delete and in order to delete the correct coupon we don't want to delete all coupons for that product, or that coupon for all products, we just want to delete the specific coupon-product that you are working with.
So we create a view that selects from the table with:
concat(CouponID,'_',ProductID) AS JoinedKey
That way we can pass in the couponID and product ID together as the key and use the server behavior to delete the correct record.
Did this help? Tips are appreciated...
