> 1. using dao
> 2. i have set up a dynaset object based on two different tables (left
> outer join).
> 3. problem is, i can't update the second table after i make changes.
> 4. the dynaset is global.
> 5. i know how to make two table recordset objects and manipulate them.
> 6. are there any costs (memory, performance, etc.) to have one global
> combination dynaset object vs. two global table recordset objects?  what
> about 3?  4?

> is there a way to create a dynaset of several tables that allows updates
> on all tables?

> tia...