[survia]

Hi,
Using PM ver 3.5.4-community
I am populating a grid control within the dynaform from the DB using a trigger. The trigger executes before the dynaform loads. The grid has a drop down control named ParentName. When the dynaform is loaded, the drop down control in each row of the grid displays the key instead of value. When the control is clicked the dropdown shows all the values and the right value related to the key gets selected as is displayed.

The trigger code that loads the grid:

@=Org = array();
$query = "SELECT ID AS RowID, ORGNAME AS OrgName, PARENTID AS ParentName, MGMT_EMAIL AS Mgmt_Email, DELIVERY_HEAD AS Delivery_Head, DELIVERY_LEAD AS Delivery_Lead, ENABLE_EMAIL AS Enable_Email, ENABLED AS Enabled FROM PMT_ORGANISATION ORDER BY ID";
$result = executeQuery($query);
if (is_array($result) and count($result) > 0)
@=Org = $result;

ParentName is the the drop down control inside the grid. It is set to display values from DB and in the SQL is
SELECT ID,ORGNAME FROM PMT_ORGANISATION WHERE ENABLED=1;
The above trigger returns the ID value as ParentName.

[survia]

Issue has been resolved. Previously this was working on ver 3.2. Looks like in the 3.5 version for drop down controls inside the grid, it is enough we set the value and not the key.