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.