Allen <profox@gatwicksoftware.com> wrote:

>Hi foxgang.

>I'm trying something I have not been doing for some time. No rude

>comments

>please.

>I have two tables. Both of which are used twice. For now just think of

>one

>table used twice. There are two counters in the table and the second

>points

>to the first so for example, record 1 may point to record 150. So I

>have a

>relation set and if I move the pointer in the first table, the relative

>

>record will be shown in the second. ok that's fine. But now I want to

>select

>fields from each table.

>Select distinct ;

>table1.field1 as f1,;

>table1.field2 as f2,;

>table2.field3 as f3,;

>table2.field4 as f4;

>into cursor mycursor.

>

>Despite the relation set I seem to get the records from table1 ok, but

>the

>records from table2 are only the first record. So while f1 and f2 are

>filled

>correctly, f3 and f4 are record 1 all the time. And not the related

>record.

>Can what I want to do be done. Im sure IO did this in VFP3 (shows how

>long

>ago it was) but it fails in VFP9 SP2.

>

>Any clues please

>

>Al

>

>

VFP Relations are used for displaying data (report or grid) or scanning the data.

Selections use the join clause and ignore active related tables.

--

Tracy Pearson

PowerChurch Software

Sent with K-9 Mail.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/158e33b5-8178-4ecb-b578-2a87f7aeb835@email.android.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.