Current() problems at cascading list

[Johan Nilsson]

Hi,

I have a problem where I have as the main connection an Access database
which the Infopath form is based on and to which I submit all data entered in
the form. I am trying to create a cascading list in this form using an xml
with the following format:

<dataFields>
<Register Element="Company">
<Work task id="Upload of JV" Value="Upload of JV 209-SK41-01-02"/>
</Register>

I use first a drop-down list box field where the 'company' value is selected
and based on that various work tasks should be availabe in the second
drop-down list box, all depending on the previous 'company choices'.

I have no problems choosing the company value in the first drop-down list
box but because I use a filter with the following format:

Element = current()/.../@Element

I get no values in the second drop-down list box. It seems as if no
information is gathered from the first drop down list box. Is it not possible
to use the current() filter with in order to create a cascading list if you
submit the information to an access database? How should I proceed if I need
these cascading lists?

Any help would be appreciated =)

Johan

 

[Anuma]

Hai Johan Nilsson

Here is the solution to your problem. Check it out this.
http://www.infopathdev.com/howto/tutorials/default.aspx?i=4e038a7f3f5b443bbe4db49f86d95fba

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

I hope this will help you.

 

[Johan Nilsson]

Hi,

I am afraid it did not help me. I have attempted and I have a form in which
I have used the tutorials you described (I have looked closely at the one I
am doing now with the previous one without finding any differences in regards
to principle...)

I have a repeating cascading list where the controls are based on an access
database by a primary connection. I assumed that I could avoid the problem of
data crossover if I wrote a filter similar to the tutorial:

Element = current()/.../@Element

However, as soon as I involve that filter in the form no selections can be
made in the second drop-down llist box. If I use a filter that says 'Element
= "Microsoft", all the work tasks appear for Microsoft if I choose Microsoft
in the firs drop-down list box. This makes me suspect that I am using the
filter 'current()' incorrectly or that the information can not be gathered?

Any other suggestions would be greatly appreciated.

Regards,
Johan

"Anuma" skrev: