[Gvsig_english] Access table and join

[Hugues Boussard]

Hi,

The problem is concerning the join option between two "Access" table with
the relation "many to 1".

table 1 :
id_1         text_1
1             one
2             two

table 2 :
id_2        text_2        id_1
1            t_1             1
2            t_2             1
3            t_3             1
4            t_4             2

I would like to join tables in order to get :
table 2 :
id_2       text_2        id_1      link_text_1
1           t_1             1          one
2           t_2             1          one
3           t_3             1          one
4           t_4             2          two


but the bug report me the following table :
 table 2 :
id_2       text_2        id_1      link_id_2      link_text_2
1           t_1             1          1                 t_1
2           t_2             1          2                 t_2
3           t_3             1          3                 t_3
4           t_4             2          4                 t_4

The problem is the same when I try to join a dbf file to an Access table.
but I managed the join between an Access file to a dbf file and between two
dbf file.

I hope it's clear...

best regards,
Hugues B.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20061201/0f2c7c06/attachment-0001.htm