Kevin,
Thanks, that works great!
With all my questions I know I am interfering with your real work, but hopefully our message trail will help others after me.
Thanks again, 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";