Hi Wayne,

The grid box will dynamically have to grow to the right depending on the no. of classes taken.

I have to represent the data in this manner.

Any ideas??

Thanks for your reply
Mark




>>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.
>
>IMO, you should display the way you have it in the first example... if not, what will you do if the student takes more classes?