9 Replies Latest reply on Apr 26, 2012 8:16 AM by Nerico

    Help with cascading/filtered drop down value lists

    Nerico

      I apologize in advanced because I know this has been discussed before, but I can't seem to get it to work properly. I need help figuring out where I'm going wrong or if I'm even on the right path.

       

      I have a course management database where I have a table called Questions. I need to assign a competency and an objective to each question. The objectives are a sub-category of the competencies. Bases on other threads I read, I've created a Competencies table and an Objectives Table. I've set up the relationship Competencies:Parent = Objectives:Parent. I have a Competency field and an Objective field on my Questions table. On the corresponding layout, I want the choices for the Objective to be filtered based on the chosen Competency. I've created a value list for the Competencies base on that table and a value list for the Objectives based on the corresponding table and set to filter base on its relationship to the Competencies table.

       

      I hope this is enough info to get started.

       

      Thanks in advance.