[dlal13]

Dear ALl,
I have a dynaform with the below scenario.
please help me in creqating a dropdown which will have the contents from a column from a PM Table.
i have defined a PM Table named COMPANY.
this has one field COMPANY_ID. this field has 6 records.
i want to list these records in the dropdown box on my dynaform.
I have created a Dropdown control
type: dropdown.
variable: projects
Datasource:Database.
DB Connection:PM Tables
and SQL as
SELECT COMPANY_ID FROM PMT_COMPANY;
Data does not display. how do i solve this.

[andreaadamczyk]

Hello,

Please, use this query "SELECT COMPANY_ID, COMPANY_ID FROM PMT_COMPANY;" since the dropdown control needs two parameters (value and label).

You can see more information in the following link: https://wiki.processmaker.com/3.1/Dropd ... Properties in the SQL property.

Regards.