I have an idea for a website I've developed over the years but have no real experience working with flash.

I would like to create a flash "template" where up to a few hundred rectangles will be arranged in rows and columns, similar to an Excel spreadsheet.

Each rectangle will have a unique ID assigned to it.

I want the flash movie to access a MySQL database with PHP to pull query results and then use that data to populate fields in the rectangles.

I also want this to operate as a map-like utility where a user could pan, zoom in, zoom out, etc.

As the user zooms into a certain "scale factor", the query/populate functionality kicks-in and starts loading the data into the rectangles.

If they pan at that level, it will refresh the data.

If they zoom back out, it will drop the data and just show the "template".

Is something like this possible?

Any tips or shortcuts?

I realize that setup of the first "template" with all of the rectangles having unique IDs would be time-consuming.

Is there any other way to set this up?

Any help with this is greatly appreciated!!

Thanks!