Webmaster Forum / Flash / Flash Remoting / May 2004

I'm trying to develop a basic database manager using Remoting/CF/ODBC (access).
And have a basic application working fine on a small, flat file db, allowing me
to ADD, EDIT, DELETE records.  I've used textArea instances bound to the
dataset to view and enter the field data

However I now want to apply this to a much larger relational database and
include an option to edit the related tables etc. I have no problems with the
CFC SQL call, and can pull-in all the data I need into a dataset and bind it to
other components as necessary. The problem is that I now have potentially 70-80
fields related to each record and unless I instantiate ALL the textAreas on the
first frame I am unable to bind them to the dataset. This, of course is not
practicable due to the lack of space on the stage. What I'd really like to do
is have a half dozen or so  frames in the movie, each one dealing with a
particular data aspect and navigate between the frames as required.

Is there a "cheat" way of binding the textAreas to the dataset from within the
movie -- i.e. almost like "refreshing" the dataset.  Or is there some other way
of achieving my target. I did manage almost to do what I wanted using dynamic
text fields linked to the dataset's "currentItem" property:

e.g.    z_number_txt.text = ds.currentItem.z_number;

but I couldn't manage to get the resolver to work with this to update the
database!

Baffled............................... mike