J
Johan Nilsson
Hi,
I have a problem querying data in an InfoPath form from an Access database.
I have set up a form with dependant drop-down lists in the registration area.
In the first form I made I had two dependant lists, 'Element' and 'Task' (in
which Task is dependant on what you choose in Element). There is also a text
field with numbers representing minutes. No problems submitting and/or
collecting data from the Access database in which I store the information.
The selections in the dependant drop down list is gathered from a secondary
source (XML document)
The query section consists of a selection of employee id and date (that is
all)
I realised that I needed an additional drop-downlist for other purposes so I
made an additional drop down list in the registration area called 'Area'.
Depending on what you choose in 'Area' you get various options in 'Element'
and depending on what you choose you in turn get various optins in 'Task'. No
problems registering data in the database with this form, however only the
text field with the amount of minutes appear when I try to collect the data
from the database. No values are registrered in neither 'Area', 'Element' nor
'Task'.
Now the funny thing is that if I choose a date in which I have registered
data with the old form (the one without the 'Area' dependant dropdown list) I
receive information in the new form (of course not in the 'Area' dropdown but
in the others such as 'Element' and 'Task').
Does anyone have any idea what I did wrong? I am sure it is something
ridiculously stupid since the original form is working perfectly and I have
basically copied the structure and layout from to the new form...
I have a problem querying data in an InfoPath form from an Access database.
I have set up a form with dependant drop-down lists in the registration area.
In the first form I made I had two dependant lists, 'Element' and 'Task' (in
which Task is dependant on what you choose in Element). There is also a text
field with numbers representing minutes. No problems submitting and/or
collecting data from the Access database in which I store the information.
The selections in the dependant drop down list is gathered from a secondary
source (XML document)
The query section consists of a selection of employee id and date (that is
all)
I realised that I needed an additional drop-downlist for other purposes so I
made an additional drop down list in the registration area called 'Area'.
Depending on what you choose in 'Area' you get various options in 'Element'
and depending on what you choose you in turn get various optins in 'Task'. No
problems registering data in the database with this form, however only the
text field with the amount of minutes appear when I try to collect the data
from the database. No values are registrered in neither 'Area', 'Element' nor
'Task'.
Now the funny thing is that if I choose a date in which I have registered
data with the old form (the one without the 'Area' dependant dropdown list) I
receive information in the new form (of course not in the 'Area' dropdown but
in the others such as 'Element' and 'Task').
Does anyone have any idea what I did wrong? I am sure it is something
ridiculously stupid since the original form is working perfectly and I have
basically copied the structure and layout from to the new form...