I was hoping someone could take the following data and
show me the steps to make it work. I can do it with a
single table but not with multiple tables

The web will have the following fields:

db NAME "DUDE"

Policy Number (Insurance Table)
LastNAme (Custome Table)
RenewalDate (Insurance Table)

1. User can add/delete new customer all fields
2. User can Update RenewalDate


I have many more fields but I would appreciate which
web controls to use and the codebehind to make this
work.
*************
*************
Here is my other post that has not received any response

I am really stumped at this point. The forum has given
me lots of ideas but nothing to show me how to do this.

How do I input a multi-table DataSet to a Web Forms DataGrid

that can be inserted, updated, and deleted?

Visual Studio 2003, SqlServer DataBase

I am trying to create a datagrid that will have
fields from 4 separate tables.

When I drag in a SqlDataAdapter and
add all four tables to my query I get the following
Messages:

Generate insert statement

The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.

Generate Update statement

The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.

Generate Delete statement

The original query has a select list that has
columns from multiple tables. The statement
cannot be generated automatically
for this type of query.