[Gvsig_english] Access table and join

Olivier Ertz olivier.ertz at heig-vd.ch
Fri Dec 1 11:22:26 CET 2006


Hi Hugues,
I understand well your problem, and the join should work properly. But, 
how did you get this strange join result ? Do you use the join wizard of 
gvSIG or did you write you own application ? Please give more details on 
what you do for creating the join.
A+, Olivier.



Hugues Boussard a écrit :
> 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. 
>  
> ------------------------------------------------------------------------
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>   




More information about the Gvsig_internacional mailing list