Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By manalidhuri
#827635
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 [email protected]@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?
User avatar
By programerboy
#827643
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://www.youtube.com/channel/UCYiyz1y8Qf4EZjMXodwH1iw/videos
https://www.linkedin.com/in/pmlearning/
Thanks

There's no way to do that. The only way to do so i[…]

Hello, If you are using a version of ProcessMak[…]

I really appreciate the work you did. I got to kno[…]

cam on

hello