hey...
i have three tables
subject(sub_id(PK),sub_desc)
questions(q_id(PK),q_desc,sub_id(FK))
answers(ans_id(PK),q_id(FK))ans_desc,istrue)
for each question entry in question table there are four entries in answers table and istrue bit will be set 1 for correct ans
like for question 1 with corr_ans 1 four entries will be
(1,1,djhjfj,1),(2,1,hdjfsh,0),(3,1,hsssh,0),(4,1,jfsh,0)
now i have to retrive this data in a grid view as per the sub_id which user will select from a combobox.. in the format
-----------------------------------------------------------------
|question(q_desc) | options(ans_1,ans_2,ans_3,ans_4)|correct_ans|
-----------------------------------------------------------------
| | | |
| | | |
-----------------------------------------------------------------
pls help..thnx