keke.. Actually, it is a simply question from original...

the real case is NOT Coins, but there are about 40 different items...
He ask for method to auto-convert One Column data into real field name and
fill in the corresponding data...

---

>STILL bad. NOT normalized. (lol)
>
>Coins should be in a child table of Students as follows (by the way, I like the StudName field...could i be a StudName?)
>
>Students: StudentID,StudName
>StCoins: StudentID,Coins,Qty
>
>You would convert by scanning through the original table, create parent Students records and child StCoins record.
>
>>One friend ask me how to convert the non-normalize dbf to standard!
>>
>>

>>badtable:
>>
>>StudentID    StudName    Coins      Qty
>>-----------------------------------------
>>PJ00001      May         5_Dollar    10
>>PJ00001      May         2_Dollar     4
>>PJ00002      John        10_Dollar    6
>>PJ00002      John        2_Dollar     5
>>PJ00002      John        1_Dollar     3
>>PJ00003      Peter       5_Dollar     7
>>PJ00003      Peter       1_Dollar    15
>>PJ00004      Susan       10_Dollar    2
>>PJ00004      Susan       5_Dollar     1
>>...
>>
>>
>>GoodTable:
>>
>>StudentID    StudName    1_Dollar  2_Dollar  5_Dollar  10_Dollar
>>-----------------------------------------------------------------
>>PJ00001      May            0         4         10         0
>>PJ00002      John           3         5          0         6
>>PJ00003      Peter         15         0          7         0
>>PJ00004      Susan          0         0          1         2
>>........
>>
>>

>>
>>
>>For Report, simply use group can do it, but how to change the table
>>into this structure na!?
>>
>>Thanks!