[Gvsig_english] join tables::many to one relationship

[Wolfgang Qual]

Hello Fran,
many thanks for your replies. Yes, I meant exactly that. Works also for me. 
Works also for lookup tables that have a string column that serves as a key 
column.
I have tested this with gvSIG 1.1.2 - should also work with the new 
version....

Best,
Wolfgang

Am Mittwoch 13 Mai 2009 12:33:01 schrieb 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