Hi Will,

Line14 is the definition for report_no.

Thanks for the reply.   I tried your solution by adding an AI column in the database and use that as the primary key in subgrid.  The grid then becomes nonreponsive.

There is one thing that I am not sure.  In your subgrid demo, you never set the primarykey for the main grid.  But for me,  the subgrid will only display the record if I set the primary key in the main grid to be “cosmic” by doing

“$grid->setPrimaryKeyId(‘cosmic’);”

Otherwise the subgrid is empty.  How does the subgrid know which record to show?  The select command for the subgrid is

select * from gene50_curation where cosmic = ?

I do not understand what the “?” refers to.   I though this has something to do with the main grid row id, but how is the main grid row id defined?

BTW, how did you put the code in the code window?  That is much easier to read.

• This reply was modified 9 years, 4 months ago by niyunyun.