Reading MYSql Data in Flash

Hi,

I’m newbie to flash. My boss gave me some flash files designed by some designers and asks me to retrieve some information from mysql database into a text box.

I have gone thorugh some tutorials in this site and figured out how to export data into an xml file and how to retrieve it within flash.

But to my bad luck, it’s not a single flash file but of several files.

The task is

  • in the file 1 there are some menu buttons.
  • when I click this menu the text box in file2 or file 3 has to be populated with data from mysql

My problem is I don’t know how to refer the text box of file2 in file 1

The designer has simply used the following scripts

on (release) {
    loadMovie("file2.swf",1);
}

The above script simply loads the file2

This swf file has same width & height as file1 and it goes behind the file1 (the menus are visible on the top)

All I want to know is how to change the text in file2->textbox when clicking button in file1

Thanks a lot for your time

Cheers
Ahmad
Hong Kong