CURRENT:


account table:
id,acctname,address
1,joe,123 First St.
2,mary,234 Second St.


purchase table:
id,productnum,prodtype,prodexp
1,222,veg,01/05/05
1,444,fruit,02/04/05
1,555,bread,03/09/06
1,777,butter,05/07/05
1,888,spice,09/06/07
1,999,coffee,02/06/05
2,444,veg,01/01/06
etc.

NEED:

id,acctname,address,productnum1,prodtype1,prodexp1,productnum2,prodtype2,prodexp2,productnum3,prodtype3,prodexp3,productnum4,prodtype4,prodexp4,productnum5,prodtype5,prodexp5
1,joe,123 First St.,222,veg,01/05/05,444,fruit,02/04/05,555,bread,03/09/06,777,butter,05/07/05,888,spice,09/06/07


only five purchases per line, then the next five go on the next line:


id,acctname,address,productnum1,prodtype1,prodexp1,productnum2,prodtype2,prodexp2,productnum3,prodtype3,prodexp3,productnum4,prodtype4,prodexp4,productnum5,prodtype5,prodexp5
1,joe,123 First St.,999,coffee,02/06/05


and so on, then on to the next account


id,acctname,address,productnum1,prodtype1,prodexp1,productnum2,prodtype2,prodexp2,productnum3,prodtype3,prodexp3,productnum4,prodtype4,prodexp4,productnum5,prodtype5,prodexp5
2,mary,234 Second St.,444,veg,01/01/06