Sounds like you will need to wait for "super Clyde" to help on this one since it is a mess of SQL errors. But I would bet money that he can figure it out for you. Sorry to not be able to help.

By the way, "Karma Charms" is a great name for your product and target customer. Nice marketing strategy!