[manalidhuri]

I have two dropdown fields in grid department and product, i want mapping between those two fields.
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?

[programerboy]

Hi,
According to your queries, them must be like this:

Code: Select all

first query:
select DEPARTMENT as id, DEPARTMENT as name from PMT_DEPARTMENT_PRODUCT;

second query:
select ID,PRODUCT FROM PMT_DEPARTMENT_PRODUCT WHERE DEPARTMENT = @@Department

https://pmlearning.info
Thanks

[manalidhuri]

Thank you so much