Gaëtan asked 9 years ago
Hi,
I have a Master grid and a sub grid.
When clicking on a record in the Master grid, I get details in the sub grid.
The Master grid works fine.
I have a little issue with the sub grid.
When clicking on the edit button in the sub grid, I get an edit prompt for the last row of the sub grid, even if I want to edit the first row.
I also get an error message when trying to save:
Couldn't execute query. Unknown column 'more_options' in 'where clause' – UPDATE crm_notes SET `note`='LIVE TEST Cx' WHERE `more_options` IN ('
Here is the full code:
Thanks
2 Answers
Abu Ghufran answered 9 years ago
The first column defined must have unique data (PK).
You can try moving the code of column options of 'note_id' before this 'more_options' column options.
Your Answer
