Luke L (5/18/2009)
Is there any reason why you can't just do this all in one query in your database using a Join?Instead of creating 2 datasets, just create one dataset and in the query do something like the following...
Select t1.cod, t1.Name, t2.Prod
FROM table1 as t1
INNER JOIN table2 t2
ON t1.cod = t2.cod
-Luke.
I agree with Luke L. Try constructing a single dataset to have all data available and then utilize it. Lookup, Shared Dataset is not available in 2005.