Dataset creation problem.........

  • Thread starter Thread starter sendtobiren
  • Start date Start date
S

sendtobiren

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.
 
Biren,

This should not be possible if you have a relation.

I know that in real live with children from who the parents are missing this
happens as well, however in a database you should in my opinion create in
those cases a parent with the name "Parent Missing".

You can choise in this by creating it in your database or in your datatable
extra rows by first looping through your Table2, use that to find the parent
in table1 and if that one does not exist create a dummy one. (it is up to
you if you do update that one in your database).

Than you can set the relation.

I hope this helps,

Cor
 
I think this problem is similar to what I have encountered in the past. Is
it possible to use a LEFT OUTER JOIN with Access (like in TSQL?) Putting it
into your read procedure you could thus create one table in your dataset
 
Back
Top