- Tue Jan 30, 2018 3:49 am
#812993
Hi PM Gurus,
I do have a form that contains multiple fields. One field is a dropdown field that contains the registered courses and using a SQL connection [Report].
If a user select a course name that is listed on the dropdown, it populates the information to the dependent fields (textboxes and drop-down).
I do managed to populate the information to textboxes but for dependent dropdown menu I'm not able to do so.
Could you please assist me on how to populate information to dropdown menu? Thanks, in advance.
Below is the SQLcode of the puldown menu's
[Pulldown of Course menu]
Field name: WorkshopNameFav
SELECT WorkshopName,WorkshopName FROM PMT_CESUPPORTREQUEST WHERE RequesterName=@@RequesterName AND APP_STATUS NOT LIKE "DRAFT" AND WorkshopName IS NOT NULL ORDER BY app_number DESC
[Pulldown of the dependent dropdown (Yes /No) ]
Field name : WorkshopCost
SELECT WorkshopCost,WorkshopCost FROM PMT_CESUPPORTREQUEST WHERE RequesterName=@@RequesterName AND WorkshopName=@@WorkshopNameFav ORDER BY app_number DESC LIMIT 1
I do have a form that contains multiple fields. One field is a dropdown field that contains the registered courses and using a SQL connection [Report].
If a user select a course name that is listed on the dropdown, it populates the information to the dependent fields (textboxes and drop-down).
I do managed to populate the information to textboxes but for dependent dropdown menu I'm not able to do so.
Could you please assist me on how to populate information to dropdown menu? Thanks, in advance.
Below is the SQLcode of the puldown menu's
[Pulldown of Course menu]
Field name: WorkshopNameFav
SELECT WorkshopName,WorkshopName FROM PMT_CESUPPORTREQUEST WHERE RequesterName=@@RequesterName AND APP_STATUS NOT LIKE "DRAFT" AND WorkshopName IS NOT NULL ORDER BY app_number DESC
[Pulldown of the dependent dropdown (Yes /No) ]
Field name : WorkshopCost
SELECT WorkshopCost,WorkshopCost FROM PMT_CESUPPORTREQUEST WHERE RequesterName=@@RequesterName AND WorkshopName=@@WorkshopNameFav ORDER BY app_number DESC LIMIT 1