I have my tblDepartment and tblCourse.
My department table is the parent and the course table is the child
I already done with their relationship which is one department and many courses.
How could I make a relational list if I choose one specific department, all of the course which is belong to that department will filter the courses to avoid the several courses in the menu list. ?