Dropdown values in databound repeating table

R

Renjith

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
 
R

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



"Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in
message 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



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
 
R

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



"Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in
message 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



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 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



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
 
R

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


"Greg Collins [InfoPath MVP]" <Greg.Collins_AT_InfoPathDev.com> wrote in
message 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.

--
Greg 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 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



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 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



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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top