When I set a FoxPro 2.5 database dynaset and using SQL keyword JOIN to
combine two tables, the dynaset become not updatable. If I open these
tables seperately, both of them are updatable. What's the problem?

It seems (although my experience is with SQL Server) that the
ODBC driver doesn't allow the updating of recordsets created
from multiple tables.  Which is rather frustrating.

My work around was to write a whole bunch of code which
determines whether or not the dynaset was from mulitiple tables,
and then building an "update ... set..values" statement
manually.  Which is a royal pain.

Duncan.