hello,
i have a page with two dropdownlists one for the company and the other is for the branches, and i have two XML Islands one is the companies Dataset and the other is Branches Dataset.
<Xml id=”xmlBranches”>
<Branches>
<Branch_ID>1</Branch_ID >
<Company_ID>1</Company_ID>
< Branch_Name>Branch1 </ Branch _Name>
</ Branches >
< Branches >
<Branch_ID>2</BranchCompany_ID>
<Company_ID>1</Company_ID>
<Branch_Name>Branch2</ Branch_Name >
</ Branches >
<Branches>
<Branch_ID>3</Branch_ID >
<Company_ID>2</Company_ID>
< Branch_Name>Branch1 </ Branch
</ Branches >
< Branches >
<Branch_ID>4</BranchCompany_ID>
<Company_ID>2</Company_ID>
<Branch_Name>Branch2</ Branch_Name >
</ Branches >
</Xml>
now i want to pobulate the first dropdownlist with the companies dataset and the the other with the branches dataset, and i want to adjust the onchange event for the companies dropdownlist to automatically filter and pubulate the branches dropdownlist with the related branches to only.
can you help me with this issue.
Thank you