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.