 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2005Dropdown values in databound repeating table
hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith I see... so it looks to me that the problem is coming from the fact that you do not have a rating PER question, which is what you are trying to do in the view. It would make more sense, for what you want, to have a data source like this: - Categories CategoryID CategoryName -- Questions QuestionID Question RatingNumber Does that help? SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:e1NmBMpGFHA.3876@TK2MSFTNGP14.phx.gbl... Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:uvMrYqlGFHA.616@TK2MSFTNGP10.phx.gbl... hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith Greg, I changed my datasource like the folowing ie. for each Question there is a set of rating mapped. So now when I select a value in Rating dropdown the values in the other dropdown doesnot change. But there is another issue, when I select a value for the dropdown that value appears twice in the list and the first value disappears. eg- If values in the dropdown are 0,1,2,3,4,5 and when I select value "2" the value "0" disappears and in its place "2" appears. So now the value "2" appears twice in the list. - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Renjith I see... so it looks to me that the problem is coming from the fact that you do not have a rating PER question, which is what you are trying to do in the view. It would make more sense, for what you want, to have a data source like this: - Categories CategoryID CategoryName -- Questions QuestionID Question RatingNumber Does that help? SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:e1NmBMpGFHA.3876@TK2MSFTNGP14.phx.gbl... Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith It sounds like something is not configured correctly with the drop-down list box itself. You could try removing it from the view, and reinserting it... I'm not sure why you are seeing two copies of the same value... and especially since you say it is replacing another value. That really doesn't make sense. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg, I changed my datasource like the folowing ie. for each Question there is a set of rating mapped. So now when I select a value in Rating dropdown the values in the other dropdown doesnot change. But there is another issue, when I select a value for the dropdown that value appears twice in the list and the first value disappears. eg- If values in the dropdown are 0,1,2,3,4,5 and when I select value "2" the value "0" disappears and in its place "2" appears. So now the value "2" appears twice in the list. - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:OmoM1bcHFHA.2752@TK2MSFTNGP12.phx.gbl... I see... so it looks to me that the problem is coming from the fact that you do not have a rating PER question, which is what you are trying to do in the view. It would make more sense, for what you want, to have a data source like this: - Categories CategoryID CategoryName -- Questions QuestionID Question RatingNumber Does that help? SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:e9Do278GFHA.3312@TK2MSFTNGP14.phx.gbl... Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:e1NmBMpGFHA.3876@TK2MSFTNGP14.phx.gbl... Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. -- Greg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:uvMrYqlGFHA.616@TK2MSFTNGP10.phx.gbl... hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith I have bound the Rating dropdown to "RatingNumber" and then Iam also populating the dropdown using the option - values from web service. Could this be a problem ? Thanks Renjith It sounds like something is not configured correctly with the drop-down list box itself. You could try removing it from the view, and reinserting it... I'm not sure why you are seeing two copies of the same value... and especially since you say it is replacing another value. That really doesn't make sense. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg, I changed my datasource like the folowing ie. for each Question there is a set of rating mapped. So now when I select a value in Rating dropdown the values in the other dropdown doesnot change. But there is another issue, when I select a value for the dropdown that value appears twice in the list and the first value disappears. eg- If values in the dropdown are 0,1,2,3,4,5 and when I select value "2" the value "0" disappears and in its place "2" appears. So now the value "2" appears twice in the list. - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:OmoM1bcHFHA.2752@TK2MSFTNGP12.phx.gbl... I see... so it looks to me that the problem is coming from the fact that you do not have a rating PER question, which is what you are trying to do in the view. It would make more sense, for what you want, to have a data source like this: - Categories CategoryID CategoryName -- Questions QuestionID Question RatingNumber Does that help? SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:e1NmBMpGFHA.3876@TK2MSFTNGP14.phx.gbl... Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith Neither of those should be causing you to see duplicate numbers. The only time I see something extra show up in a drop-down list box is if the current value of the field to which the control is bound is not part of the list of options. Then it will show up at the top of the list. But that doesn't account for a list option disappearing. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I have bound the Rating dropdown to "RatingNumber" and then Iam also populating the dropdown using the option - values from web service. Could this be a problem ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:emu153pHFHA.2784@TK2MSFTNGP09.phx.gbl... It sounds like something is not configured correctly with the drop-down list box itself. You could try removing it from the view, and reinserting it... I'm not sure why you are seeing two copies of the same value... and especially since you say it is replacing another value. That really doesn't make sense. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:O7F$fsiHFHA.1860@TK2MSFTNGP15.phx.gbl... Greg, I changed my datasource like the folowing ie. for each Question there is a set of rating mapped. So now when I select a value in Rating dropdown the values in the other dropdown doesnot change. But there is another issue, when I select a value for the dropdown that value appears twice in the list and the first value disappears. eg- If values in the dropdown are 0,1,2,3,4,5 and when I select value "2" the value "0" disappears and in its place "2" appears. So now the value "2" appears twice in the list. - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:OmoM1bcHFHA.2752@TK2MSFTNGP12.phx.gbl... I see... so it looks to me that the problem is coming from the fact that you do not have a rating PER question, which is what you are trying to do in the view. It would make more sense, for what you want, to have a data source like this: - Categories CategoryID CategoryName -- Questions QuestionID Question RatingNumber Does that help? -- Greg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:e9Do278GFHA.3312@TK2MSFTNGP14.phx.gbl... Greg, Thanks for the response. My datasource is something like this - Categories CategoryID CategoryName -- Questions QuestionID Question -- Ratings RatingNumber CategoryID Questions and Ratings are related to a category. I have a repeating table for the "Category" group , within that I have another repeating table for displaying "Questions" and in this same table against each question for a category Iam displaying the "Ratings" in a dropdown which is bound to the RatingNumber field. Repeating table format is something like this. ---------------------------------------------------------- Category1 ---------------------------------------------------------- Question 1 Ratings(1,2,3,4,5) in dropdown Question 2 Ratings(1,2,3,4,5) in dropdown Question 3 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Category2 ---------------------------------------------------------- Question 4 Ratings(1,2,3,4,5) in dropdown Question 5 Ratings(1,2,3,4,5) in dropdown Question 6 Ratings(1,2,3,4,5) in dropdown ---------------------------------------------------------- Here for "Question 1" when I select a Rating say "2" from dropdown the rating for "Question 2" & "Question 3" changes to "2". I tried re-inserting a new dropdown as you said but it doesnot work. Any other solution ? Thanks Renjith "Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in message news:e1NmBMpGFHA.3876@TK2MSFTNGP14.phx.gbl... Question: Does the field to which the drop-down list is bound exist within the repeating node, or outside of it? INSIDE: Field1 Table Row Field2 Field3 (drop-down list bound here) ... FieldN OUTSIDE: Field1 (drop-down list bound here) Table Row Field2 ... FieldN If it is inside, then it sounds as if your drop-down list box is bound to only the first instance (row) in the repeating table. You might try reinserting a new drop-down list box and see if the problem goes away. -- Greg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Renjith" <renjith@netgalactic.com> wrote in message news:uvMrYqlGFHA.616@TK2MSFTNGP10.phx.gbl... hi, I have a databound repeating table with a dropdown list in each row. When I change the dropdown list value in one row the selected value of dropdown in all the other rows chnages to this new value. Also this new value selected appears twice in each dropdown. Any solution to this weird problem ? Thanks Renjith |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.