0 Replies Latest reply on Apr 2, 2014 2:23 PM by SmileySnr

    Filtering a dropdownlist

    SmileySnr

      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