[V4MD] findAllLinked from two subTables

[info at vallemediatime.com]

Ho Ruslan
I try to explain you (better I can) with a simple example:

T1
ID  |  Person  |  Phone  |  Code
------------------------------
1      Brown      123        1
2      Smith        456        2
3      Parker      287        1
....

T2
ID  |  Course  |  Level
------------------------
1      Science     1
2      Math         1
3      Math         2
...

I create a link between T1<>T2

When I search allLinked I need to get, not only linked from T1 to T2 like
this:
eg find allLinked to Math, show from T1
1      Brown      123        1
2      Smith        456        2

but also the Person with Code = 2
2      Smith        456        2

in the same time (if possible) I wnat to get the Math Level 1 or 2 also

My idea is in this pseudo code;
findAllLinked from T1 to T2
show only T1 Person with Code = 1
where T2 Linked Courses have Level = 2

I hope that you can understand me :-)
Thanks a lot
Paolo


----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina-beta at lists.macserve.net>
Sent: Tuesday, September 20, 2005 9:31 PM
Subject: Re: [V4MD] findAllLinked from two subTables


> On 9/20/05 9:20 PM, "info at vallemediatime.com" <info at vallemediatime.com>
> wrote:
>
> >>> I'm tryng to get a findAllLinked from two subTables like this:
> >>
> >>> rs1 = gDb.table(T1).field("iscF2").findValue("1", gDb.table(T1))
> >>> rs2 = gDb.table(T2).field("angF30").findValue("1", gDb.table(T2))
> >>
> >>> -- now can  I do something like this?
> >>>  rs3 = link.findAllLinked(rs1, rs2)
> >>
> >> I think no, although I have not understand.
> >>
> >> You get two sets for 2 different tables.
> >>
> >> But what operation
> >>
> >>       rs3 = link.findAllLinked(rs1, rs2)
> >>
> >> Is going to do ???
> >>
> >> Link -- is link between T1 and T2 ?
> > Yes
> >
> >> Or this is link to T3 ?
> > No, of course.
> >
> >> In both case-sensitive  NO.
> > Aaargh... :-(
> >
> > Can you suggest me an alternative idea for this type of searching?
> > 1. SQL way
> > 2. change table structure
> > 3. some other idea?
>
> I do not see yet what you try to find !
>
> You have s1 for T1
> And have s2 for T2.
>
> What you want find now ?
>
> Set for which table ?
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.0/103 - Release Date: 15/09/2005
>
>