Repeating Cascading List problem

[Johan Nilsson]

Hi,

I have followed the instructions on

http://www.infopathdev.com/howto/tutorials/default.aspx?i=9f6fda3a14c14ac4924cf0a382928432

with the intention of creating a repeating cascading list from a
hierarchical data source which is to be stored in an Access database once
submitted.

The cascading list works perfectly, the registration into the database works
perfectly however querying the information back into the form from the
database does NOT work properly.

If I register something for a specific date and then tries to gather that
information nothing appears. However, when removing the "Clearing selections
after changes" (described at the bottom of the above web site) for the first
dependant drop down-list, it gathers at least the information for the second
and third dependant drop down-list. But no information appears in the first
one.

To summarise, it seems that something is wrong with the first drop down list
and how it is set up. However, how is it possible to be able to register the
information correctly in the database but in the same form and datafield not
be able to collect that same information???

Any suggestions and help would be greatly appreciated =)

Johan

 

[S.Y.M. Wong-A-Ton]

It is difficult for me to follow your scenario. How did you create your form?
Did you bind it to the database? Where are the lists getting their data from?
Tables in the database? And how are you doing the querying?

If nothing else, always pay attention to what you put in the "Value" field
of a drop-down list box and not what you put in the "Display Name" field,
since the "Value" field is usually stored. Perhaps you have duplicate values
somewhere?