[Gvsig_english] join tables::many to one relationship

[Francisco José Peñarrubia]

Hi Wolfgang.

I was thinking about this e-mail and I realized that when you say a M:1 
join, maybe you mean something as a Lookup table. For example, I may 
have a field with many records with 0, some others with 1, others with 
2... etc.
And another table (lookup table) with the description of this 0, 1 and 
2, let's say for example ALL DIRECTIONS (ALL), FROM NodeA to NodeB (FT) 
and REVERSE DIRECTION (TF).

I have done the JOIN and it works, but I agree that we must to fix many 
things (for example, size of buttons and better field management => in 
my case, the link works because both fields are integers).

Hope it helps.

Cheers.

Fran.

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
>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: gvSIG_example_join.png
Type: image/png
Size: 103458 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20090513/179d1a1f/gvSIG_example_join.png