Hi
Is it true that you cannot use a bound datagrid if you're using a select
statement with a join in it. That is the error i'm getting when trying to
..acceptchanges and .update....

Additional information: Dynamic SQL generation is not supported against
multiple base tables.

Is there anyway I could have two dataadapters - one for each table. In
essence, i'm only trying to update two fields (foreign keys)
I don't know how to code around this... Please help
Thanks