M
Mullie21
I've read most of the material on Cascading Lists from this website, but I
still can't figure this out. I have a form based on an Access Database. The
first cascading list I am trying to accomplish involves a Year field and Date
field, residing in the same table.
What I want to do is have the user populate a Year drop down list, and then
in the body of the form (a repeating section), the available Dates will
populate for the partiucular year in a second drop down list.
Currently I am populating the data in the fields using secondary data
sources. The secondary data sources are MS Access queries based on my MS
Access database (main source). Everything is fine, until I add the filter
for the cascading list. At this point, the Date field becomes blank. The
filter I've been using is as follows:
@Date[@Year = current()/dfs:myFields/dfs:dataFields/@Year]
@Date[@Year = /dfs:myFields/dfs:dataFields/@Year]
I thought I read somewhere that cascading lists do not work for secondary
datasources. Is this true? What am I doing incorrectly
I've tried populating the drop-down lists with data from the main datasource
and I can't get this to work. The lists won't even populate with values.
Any help is appreciated.
Chris
still can't figure this out. I have a form based on an Access Database. The
first cascading list I am trying to accomplish involves a Year field and Date
field, residing in the same table.
What I want to do is have the user populate a Year drop down list, and then
in the body of the form (a repeating section), the available Dates will
populate for the partiucular year in a second drop down list.
Currently I am populating the data in the fields using secondary data
sources. The secondary data sources are MS Access queries based on my MS
Access database (main source). Everything is fine, until I add the filter
for the cascading list. At this point, the Date field becomes blank. The
filter I've been using is as follows:
@Date[@Year = current()/dfs:myFields/dfs:dataFields/@Year]
@Date[@Year = /dfs:myFields/dfs:dataFields/@Year]
I thought I read somewhere that cascading lists do not work for secondary
datasources. Is this true? What am I doing incorrectly
I've tried populating the drop-down lists with data from the main datasource
and I can't get this to work. The lists won't even populate with values.
Any help is appreciated.
Chris