Multiple instances of a customer, HELP

[Myriad_Rocker]

Okay, here's the thing. I have a customer table...in it, the customer can exist multiple times but with ONLY ONE item type that they're purchasing. That being said, a customer can have multiple item types but cannot have more than one item type of "11". See what I mean?

I want to be able to generate a report based off of the customer and it would list the item types at the bottom...but instead, I'm getting a report for EVERY row in the table.

I have attached a database example of what is happening for better illustration.

 

[Myriad_Rocker]

I new that was a resolution but I wanted to try and get away from doing another table....oh well....