Hi M

I'm presuming the second table contains some statistics about the courses and is therefore linked to it by some key, which you haven't detailed. If this is the case then you want a query/view that brings the two together in a cursor, then programmatically set the cursor to be the recordSource of your grid. e.g. something like:

Select course.coursenumber, course.coursename, ;
       table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ;
       table2.chr1, table2.g4, table2.g5, table2.wm1, table2.g6, table2.tot2, table2.ltot, table2.chr2 ;
  from Course ;
  inner join on table2.courseFK = course.coursePK ;
  into cursor csrCourseStats

Thisform.myGrid1.RecordSource = "csrCourseStats"

HTH

Terry

>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