a company has many branches, each branch has a single location
company A can have branch 1 in location Q
company A can have branch 2 in location R
company A can have branch 3 in location S
company B can have branch 4 in location Q
company B can have branch 5 in location R
i want to filter the branch selections when i choose a company BUT i also want to show the location of a chosen branch once a branch is selected. I've got the first part working where the company-code is used to filter the branch list (branch has branch name and branch code)
what i cant figure out is how to then show the location of a branch once the branch is selected from a drop down list.
I have the following scenario
a company has many branches, each branch has a single location
company A can have branch 1 in location Q
company A can have branch 2 in location R
company A can have branch 3 in location S
company B can have branch 4 in location Q
company B can have branch 5 in location R
i want to filter the branch selections when i choose a company BUT i also want to show the location of a chosen branch once a branch is selected. I've got the first part working where the company-code is used to filter the branch list (branch has branch name and branch code)
what i cant figure out is how to then show the location of a branch once the branch is selected from a drop down list.