How to associate list box entries with rows of a table

J

Josh

Have a table that has ~5-10 entries in it and would like to make a drop-down
list out of each row in a particular column (it seems like this would be an
extremely common goal). I have made a secondary data source which is the
table in question, and when I:
1. click on "Drop-Down List Box"
2. select my data connection (just a table)
3. click apply

I get the error message (in the Window "Drop-Down List Box Properties", Data
tab)
"You must select a repeating group or field from the data source to create
entries for the list box."

There's something I'm not understanding here.... I just want to be able to
list these rows and chose one. What should I do?

Thanks
Josh
 
K

Kalyan Reddy

Hello Josh,

Your secondary data sources should be in the following format.
<my:group1>
<my:group2>
<my:field1></my:field1>
<my:field2></my:field2>
<my:field3></my:field3>
</my:group2>
</my:group1>

Where field1, field2, field3 are your columns in the repeating table.

Now if you want to show only field2 in the drop down select field2 from the
secondary data source which is a xml file.

I hope this helps you.
 
J

Josh

I'm sorry - I think i wasn't clear in my original post!

My secondary data source is a SQL database - not an XML file or webservice.
I am not creating an XML file, I am just pointing it at a database, so I
cannot change the structure of it.

I was using the terms "row" and "column" and "table" to indicate this, but
probably should have just said, "SQL database"!

So I still have the issue.

Thanks
Josh
 
Top