Hi,

I need to represent data in a grid box from a table thats looks as follows :

         Student No         SubjectCode         Mark
Record1  1999               BAF1F               78 
Record2  1999               GFDTA               50
Record3  1999               JHGUG               60  

.etc.

The grid box needs to display just one line for these 3 records .eg.

Student No     BAF1F      GFDTA     JHGUG
1999            78         50        60

Overwriting any of these marks should also update the table.

Can someone give me the best way to go about this, basically I need to be able to set up some kind of matrix based on the table.

Cheers
Mark