Environment: FlashBuilder 4.6, Wamp 2.4 with Zend Framework.

 

mySql

7 base tables

 

lecturers

students

modules

ulms

studentprogress

studentmodules

modulecontents

 

I want to setup filtering across a number of the tables ... just one example
is explained below;

 

ModulesContents is a table which shows which ULMs are in which Module

 

I use dropdownlists when  adding data to this table ...

dropdownlist 1 (to list all the modules currently in the DB)

dropdownlist 2 (to list all the ulms in the DB) and finally

dropdownlist 3 (to list all the lecturers in the DB)

 

These all work to a fashion. They all indeed return lists of all the
elements in the database.

 

Lets look at some data

 

Modules Table

Module1,Module2,Module3,...

 

Ulms Table

Ulm1, Ulm2,Ulm3,Ulm4,Ulm5,Ulm6,...

 

Each module can contain upto 8 ULMs (Units of Learning Material).

 

 

A sample ModuleContents table might look like

 

Module 1 Ulm1

Module 1 Ulm2

Module 1 Ulm3

 

 

Each time I click the dropdown menu for Ulms with Module1 selected, I see
the full list of Ulms.

Ulm1, Ulm2,Ulm3,Ulm4,Ulm5,Ulm6,...

 

What I would like to see is a filtered list based on what is NOT in the
module already

ie in this case ...

Ulm4,Ulm5,Ulm6,...

 

Any idea How I could do this?

 

Any help would be appreciated



--
View this message in context: 
http://apache-flex-users.2333346.n4.nabble.com/Filter-a-dropdown-list-tp5968.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.

Reply via email to