Hi all
I am struggling to understand how to achieve a cascading combo box.
i have three tables
Table_Roles
ID | role |
Table_Department
ID | department |
Table_Roles_Departments
Role_IDFK | Departments_IDFK
and I have created a many to many relationship
when i run the query it returns all the information as it should, but I'm stuck, what do to from here, how do i connect the two cascading combo boxes to the query
I am struggling to understand how to achieve a cascading combo box.
i have three tables
Table_Roles
ID | role |
Table_Department
ID | department |
Table_Roles_Departments
Role_IDFK | Departments_IDFK
and I have created a many to many relationship
when i run the query it returns all the information as it should, but I'm stuck, what do to from here, how do i connect the two cascading combo boxes to the query