dxDataGrid - Cascaded dropdown editors

Hello Ahmad,

You can handle the editorOptions.onValueChanged event of the required editor and access another editor using the dxForm.getEditor(field). For example:

JavaScript
{  
                dataField: "Project_ID",  
                editorType: "dxSelectBox",  
                editorOptions: {  
                    items: bookingType,  
                    valueExpr: 'Project_ID',  
                    displayExpr: 'text',  
                    onValueChanged: function (e) {  
                        var projectEditor = $("#infoForm").dxForm("instance").getEditor("Project");  
                       // set options for the projectEditor editor  
                    }  
                }  
}  

"infoForm" in this example is ID of dxForm.

I still don't get it.

Let say, I have two dropdowns for "Project" & "Worker"

there are Project A and B. Project A has workers X, Y, Z. Project B has workers K,L,M, N.

When I choose Project A. Only workers X, Y, Z comes out in the dropdown "Worker".

How to implement this using dxForm ?

Here is my code in PHP & Java script :

<script id="jsCode">

$(function ()
        {

var projects = <?= $projects ?>;
    var workers = <?= $workers ?>;

$("#form").dxForm({

items: [
        {
            dataField: "Project",
            editorType: "dxSelectBox",
            editorOptions: {
                items: projects,
                displayExpr: "name",
                valueExpr: "id",
            },
            validationRules: [{
                type: "required",
                message: "Project is required"
            }]
        },
        {
            dataField: "Worker",
            editorType: "dxSelectBox",
            editorOptions: {
                items: workers,
                displayExpr: "name",
                valueExpr: "id",
            },
            validationRules: [{
                type: "required",
                message: "Worker is required"
            }]
        },

…

Hello,

Since the issue is different from the one discussed in the original thread, I've created a separate ticket on your behalf (T457525: How to implement cascading drop-down editors in dxForm). It has been placed in our processing queue and will be answered shortly.