Is someone a loyalty customer because they have an entry with PurchaseDetails of 'Loyalty Customers' on a particular day, or is that designation inherent to the customer himself/herself?
I think you may have a design issue here but I don't want to jump to conclusions as to what you're really trying to do.