[Gvsig_english] join tables::many to one relationship

Francisco José Peñarrubia fjp at scolab.es
Wed May 13 11:55:12 CEST 2009


Hi Wolfgang.

I think you must distinguish between JOIN and LINK. The behaviour of 
gvSIG is the same (or should be) as ArcView 3.x. Whenever you need a 1:1 
relation, you can do a JOIN. If you need a 1:N relation, then you have 
to do a LINK (when you select one city, for example, all shops with the 
same city code maybe selected).

You can read AV 3.x docs if you don't believe me ;-):

An interesting link to know why to use one or other:

http://www.quantdec.com/SYSEN597/GTKAV/section4/chapter_16.htm

Cheers.

Fran Peñarrubia
gvSIG Team.



Wolfgang Qual escribió:
> Dear list,
> I am a little bit irritated about the join-table function of gvSIG. 
> Does the joinfunction of gvSIG only allow to perform 1:1 relationships? Is M:1 
> (many to one) not supported? If not: are there plans to realize this feature?
> M:1 would be extremely important for me. Unfortunately, the english handbook 
> does not say anything on this detail.
> I would be _most_ grateful, if someone could send me a short answer on this.
>
> Best,
> Wolfgang
> _______________________________________________
> 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