Environment: FlashBuilder 4.6, Wamp 2.4 with Zend Framework.
7 base tables
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
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.
What I would like to see is a filtered list based on what is NOT in the module already
ie in this case ...
Any idea How I could do this?
Any help would be appreciated