>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown