You mean show a video on offering a percentage discount based on order total? OK. I'll add that to the list.

I'm in the process of developing a "Rewards Point" system for a retail Golf Shop.  The idea is that customers could sign up free for the rewards program and each time they make a purchase they accumulate 'Points" (in the Points table) based on the total pre-tax purchase amount.  It's kind of like McDonalds rewards.  Certain designated products can be purchased with accumuilated Points.  Points would expire after a designated period.  Rewards Customers would also be entitled to special sales only for them and other perks such as free grip installation, etc.

My Customer table will have RewardCustomer Y/N field which will be used to trigger the rewards calculations when a sales transaction (or return) is made for that Customer.   There are a lot of other associated details but that is the basic concept.

Since I'm basically making this up as I go along, I thought it would be a good subject for you to show us how is SHOULD be done.

Thanks!

I just re-read my post.  Sorry for the typos.

This is an excellent idea. Probably a little too complex for a TechHelp video, but I'd be happy to add this to a Developer class.

Sound great.  Thanks!!  Be looking forward to it. Will be very interesting to see your approach vs. mine.  Hope I'm not too depressed! :)