I still need help. I managed to build the grid as desired: During the process of adding a new record, when I select a customer in the first dropdown only the jobs of this customer are shown in the second dropbox. When the input is finished the grid seems ok.
But when I update the browser all job entries disappear. The data in the database is not touched since I use IDs. But nevertheless this is not as expected. I guess I didn’t really understand the correct application of the event triggers. Sorry
Can you have a look into this?
Here is my code (with focus on line 87-115):
I don’t want to be too pushy, but is there really no one who can help me with this problem? Or is there still a lack of information from my side?
On line 112, Try adding:
$str = $g->get_dropdown_values("select pk as k, Bezeichnung as v from Auftraege");
$col["editoptions"]["value"] = $str,
To fill the list, you will need all key:value mappings but when you provide an [“onload”][“sql”] query, it limits them to your where condition for edit/add dialog.
Hope it solves your case and apologies for the late reply.
Abu Ghufran - Dev Team
Grid 4 PHP Framework
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?