Since there is one datasource for a formView control, and one sql update
statement for the datasource, how can I update my normalized database (with 2
tables furnishing the data for the formView) since sqlServer doesn't allow
update statements with more than one table?

Thanks for any suggestions

Instead of using sqlDataSource use an ObjectDataSource whose UpdateMethod
would execute  SQlCommands to update more than one table.  For samples on
using objectDataSource with Business Logic Layer you may refer to the Quick
Start Tutorials http://www.asp.net/QuickStart/aspnet/doc/data/objects.aspx#bll

Show quoteHide quote

GridView TemplateColumn
Accessible GridView
Intercepting the DataGrid
ASP.NET datagrid
System.Web.UI.WebControls.Image control not refreshing
Browse for file - on the server
Inheritance
FormView update parameter values
GridView Constituents
Postback and return view