BorlandTalk.com

Yew Mun Tai · Guest

Hi,

Currently, I have 2 tables in this manner.

Student (id, name)

result(student id, subject id, score)

I need to display in a grid the columns
(student id, student name, subject 1 result, subject 2 result, etc)

currently wat i did was define a dbgrid for table student. then on form
create, add the columns of subjects to the dbgrid. then onDrawColumnCell,
set the values of the result fields. This works fine except tat i can't sort
using the results. i need asort using the result. Anyone have suggestions
for me?