That is when user select any option from dept dropdown the products which comes under that selected dept will remain in product dropdown.
I have tried two queries
For department dropdown
select ID,DEPARTMENTfrom PMT_DEPARTMENT_PRODUCT;
and for product
select ID,PRODUCT FROM PMT_DEPARTMENT_PRODUCT WHERE DEPARTMENT IN
(SELECT DEPARTMENT FROM PMT_DEPARTMENT_PRODUCT WHERE DEPARTMENT=@@Department);
Note:(@@Department is the variable of department dropdown)
but this is not working for grid control(i.e for the dropdown which are in grid control)
so is there any another solution for this?