Liew,

>I hit the following error when I tried to update the record row in GridView, please advise. Thanks.
>
>

>[Message]    = Dynamic SQL generation is not supported against multiple base tables.
>

This is an ADO.NET error message. It sounds like you retrieved data from multiple tables and then tried to update. ADO.NET doesn't handle updates to multiple base tables very well. That said, rather than using dynamic SQL to update your data, you can use the Business Layer Generator to generate insert, update, and delete stored procedures instead. Check out the MM .NET Dev Guide topic "Using the Business Layer Generator | Step 4: Data Access Layer Options | Create New Stored Procedures.

Best Regards,