Hi All,

I have two access databases. First contains a table which contains
userids. The second one contains the users records.

I tried to create a dataset which will query in these two databases and
get two datatables. I tried to add relation between these two
datatables.

But while setting the relationship it gives error because each & every
records in the first table does not contain related records in the
second table.

e.g.

Table 1                                     Table 2
---------------------------  --------------------------------------
Id       UserId            UserId              UserName
---------------------------  -------------------------------------
1        1001               1001                User One
2        1001               1002                User Two
3        1002               1003                User Three
                               1004                User Four

Can anyone help me in this issue...............

Thanks,
Biren.