Update two table in one datagrid

[Ad_dee]

Dear all,

I have created a dataset which gets the data from two table and show them in
one datagrid. However, when I add the Edit column to the datagrid, I find that
DW only allow me to choose one table to update. Is there any way for me to
update the DB?

Eg Table1 have col: productID, productCatID, ProductDesc
Table2 have col: productCatID, productCat

Thanks!!

Ad_dee

[Paul Whitham TMM]

Not with the built in DW code because the update statement is written inside
of the custom tag. With hand written code it is relatively easy to do. I
suggest that you have a look at the articles on [url]www.4guysfromrolla.com[/url] on
the datagrid as this is will show you how.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Ad_dee" <webforumsuser@macromedia.com> wrote in message
news:d2eekj$se$1@forums.macromedia.com...

> Dear all,
>
> I have created a dataset which gets the data from two table and show them

in

> one datagrid. However, when I add the Edit column to the datagrid, I find

that

> DW only allow me to choose one table to update. Is there any way for me to
> update the DB?
>
> Eg Table1 have col: productID, productCatID, ProductDesc
> Table2 have col: productCatID, productCat
>
> Thanks!!
>
> Ad_dee
>