Using the built-in VFP5.0a query designer, I ended up with the data the way you pictured it, except the 1, 2, and 3 were shown as C_1, C_2, and C_3. I know there's a way to get it back to what you want, but I can't think what it is this late. :)
However, the SQL code to get that data doesn't seem to care that it's not numeric:
SELECT *;
FROM size;
GROUP BY Size.code, Size.size;
ORDER BY Size.code, Size.size;
INTO CURSOR SYS(2015)
DO (_GENXTAB) WITH 'Query1'
BROWSE NOMODIFY
Give it a shot, it worked for me.
==Carl
Carl J. WarnerVFUG OfficerThe early bird gets the worm, but the second mouse gets the cheese.