• 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.