How to associate list box entries with rows of a table Josh 12.07.2006 22:06:03 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

RE: How to associate list box entries with rows of a table Kalyan Reddy 13.07.2006 07:53:01 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. -- Kalyan Reddy Visit http://www.autonomysystems.com "Josh" wrote: [Quoted Text] > 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 > >

RE: How to associate list box entries with rows of a table Josh 13.07.2006 12:27:02 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 "Kalyan Reddy" wrote: [Quoted Text] > 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. > -- > Kalyan Reddy > Visit http://www.autonomysystems.com > > > > > "Josh" wrote: > > > 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 > > > >