ListBox Component dynamically selecting xml source from user selection in another listbox

I have a three column layout.  Column one is a list box. Selecting an item from column one, presents the user with a selection of sub-items in listbox two (column two of the layout).  The xml data I am using for options/sub options is extrememly large and cannot be reformatted (I can't redevelop the node structure with further sub nodes etc...)  I want to assign the url of the xml connector for column two dynamically using actionscript based on the users selection from the first list box - or something else which will achieve the same effect(!) I've tried various actionscript in the on change() handler of the first column, but nothing seems to work.

instance name of listbox to be changed - selectList
instance name of xml connecter - dynamicXML
instance name of listbox 1 (column one) - serviceList

I have set up the xml connector for column two with an initial URL and the xml is triggered and sat in frame one of the movie with all other actionscript and data connections for the movie.

I'm using flash mx 2004 Professional, v7.2  on Mac os X 10.3.6.

Please help!
nelmatAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AgentSmith007Commented:
nelmat,

Can you attach a snippet of your XML file structure?
0
negatyveCommented:
this is a possible solution:

var responder:Object = new Object();
responder.change = function(evt:Object):Void
{
      dynamicXML.URL = evt.target.selectedItem.data.your_data_with_xml_url;
      dynamicXML.trigger();
};
responder.result = function(evt:Object):Void
{
      trace(evt.target.results);
      // do what you want with loaded data
};
selectList.addEventListener("change", responder);
dynamicXML.addEventListener("result", responder);
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Flash

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.