Master Grid / Subgrid and Custom made column with Edit button

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

Perfect, it now works.
Thanks

Your Answer

9 + 20 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?