Can not get the cascading fields to work.
When you select the Activity Taken cmdButton and then on School select "Lowell" you should have three Sessions (per the refSchoolActivity table)
"CS Porter" should give you three and so should "Big Sky" and then narrow down to the Grade, component and then Activity.
I just get the same one selection (from Session to Activity)
Are my tables set up wrong, or am i missing something. (5 Cascading Tables in the table help section) not sure about linking the two requests but here is the one regarding the tables http://www.access-programmers.co.uk/forums/showthread.php?t=291154
This is for an afterschool program that wants to narrow down the selection based on the programs schools (8 of them) then by session, by grade, and then arrive at an activity. They can all mix an match activities based on session, grade level, core component.
In order to meet the size requirement I have removed parts that do not tie with this problem
When you select the Activity Taken cmdButton and then on School select "Lowell" you should have three Sessions (per the refSchoolActivity table)
"CS Porter" should give you three and so should "Big Sky" and then narrow down to the Grade, component and then Activity.
I just get the same one selection (from Session to Activity)
Are my tables set up wrong, or am i missing something. (5 Cascading Tables in the table help section) not sure about linking the two requests but here is the one regarding the tables http://www.access-programmers.co.uk/forums/showthread.php?t=291154
This is for an afterschool program that wants to narrow down the selection based on the programs schools (8 of them) then by session, by grade, and then arrive at an activity. They can all mix an match activities based on session, grade level, core component.
In order to meet the size requirement I have removed parts that do not tie with this problem
Attachments
Last edited: