[Gvsig_english] join tables::many to one relationship

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


Sorry, I forgot to put the link fields:

link field 1: DIREC in table Attributes of paradas.shp
link field 2: IDLINK in table Looup2.dbf

Francisco José Peñarrubia escribió:
> 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
>>   
>
>
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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