Master Grid / Subgrid and Custom made column with Edit button

QuestionsMaster Grid / Subgrid and Custom made column with Edit button
Gaëtan asked 3 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:

http://pastebin.com/k4xHuEjz

Thanks

2 Answers
Abu Ghufran answered 3 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.

Gaëtan answered 3 years ago

Perfect, it now works.
Thanks

Your Answer

4 + 0 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!