Ted,

>Unfortunately when I do a save as below I get an error:
>// Save the DataSet (the GridView automatically binds back)
>this.Save(this.oSurveyDue, dsSurveyDue);
>
>InvalidOperationException was unhandled by user code.
>Dynamic SQL generation is not supported against multiple base tables.

When using dynamic SQL, you can get the save operation to work properly by setting the business object's UpdateSelecteStatement property. When you set this property the DAL uses it to generate insert, update, and delete statements rather than using the original SELECT statement.

In your business object's constructor, just set the UpdateSelectStatement property to something like this:

this.UpdateSelectStatement = "SELECT * FROM Survey";