>Hello! Too much coffee! ;-)
>
>John, VFP 6
>John, Office
>John, VB (yeah, right)
>
>Is not normalized!
>
>
>>Granting that I've *only* had 3 cups of coffee this morning, but it seems to me that the table is normalized (well expect for the name, but that aside)...just that Karl needs a crosstab view of it.
>>
>>Yeah, I think it is possible to study TOO much! I'm FRIED! :)
>>
>>>My first take on this was why his table was structured this way to begin with. Seems a serious candidate for normalization.

Yep... you need to break that into two tables. <g>

Somethin' like...

person product
pk_personid pk_productid
cname fk_personid
cprodname


Wayne