Hi,

I'm trying to create a form from the BizForm tools that makes use of a dropdown-list for populating one of the fields in the form. I plan to use this as a webpart once done.

The form (called Experts Feedback Form) has four fields namely:
(a) From
(b) To
(c) Subject
(d) Message

The 'To' field is the one that is a dropdown-list field type, set to SQL Query.
It contains the ff:

"SELECT EmailAddress FROM KenticoCMS_Expert"

I created a custom table called 'KenticoCMS_Expert' with two fields: 'Expertname' and 'EmailAddress' for use with the To field. I'm trying to figure out what's wrong with the above-mentioned query, because I get the following message:

"Cannot find column 1."

If I run this query in an independent SQL Query Analyzer however, it works out fine.

For some troubleshooting attempt, I tried replacing the query with

"SELECT * FROM KenticoCMS_Expert"

and what I get instead is the underlying "ItemID" field (present during the creation of the custom table).

Has anyone done/encountered something like this before? Or.. am I missing a macro tag somewhere in the query, etc? All and any input is much appreciated.