I have a fact table where a single record may have multiple permutations of a single attribute so I need some advice as to how I may go about handling the relationships of these attributes to their appropriate dimension.

As an example, a person may have a single record in the fact table but may list up to 5 different States in that record which go back to a State Dimension.

What is the best approach to associate those 5 States for that 1 individual to the State dimension?

So this isn't a true many to many relationship in the sense that the same individual isn't listed 5 times in the fact table for each State. But rather that the 1 individual is listed in the fact table but may list many States in the single record.

If more clarification of the problem is required, please let me know but I believe the issue is pretty straight forward as I've explained.

Thanks much for any advice whatsoever!