hi all,
would you help me,

i want to get fields form 2 tables to mygrid as under
table1 have course number,course name
table 2 have g1,g2,wm1,g3,tot1,chr1,g4,g5,wm1,g6,tot2,ltot,chr2

i need to see at mygrid1 course name from table1
and g1,g2,wm1,g3,tot1,chr1,g4,g5,wm1,g6,tot2,ltot,chr2
from table2

and i need to save(append) at table2 COURSE NUMBER from table1
and all records have g1,g2,wm1,g3,tot1,chr1,g4,g5,wm1,g6,tot2,ltot,chr2

course name  g1   g2  wm1  g3  tot1  chr1 g4 g5 wm1 g6 tot2 ltot chr2
  math       14.5 12  7    40   73.5  ..............................
  since .............................................................
   .
   .
   .
   .
   .

thanks.
m.qasem