>>Say I want to open 5 tables to be used in a form. Do I have to create 5 CA's in the DataEnvironment of the form, one for each table?
>
Dimitry.
So far, my work with the CA's hasn't had to deal with Dataenvironment of a form. My mind is simple. I think of the CA as a Connection object, not a true Manager object. In my mind there is a difference. It connects to a table in the database and gets a record set for a manager object to deal with. One CA for each table. The Updates, Inserts & Deletes are simple. I create the cursors and let the manager object link them, manipulate them, update them, close them, as necessary. The CA is stupid where the Manager object using it is smart. Therefore I do use 1 CA instantiation per table. This will change in the future when the use is more intensive because it may entail too many hits to the backend for one operation. For now I've got to keep it simple.