relations VFP9 SP2

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

Re: relations VFP9 SP2

Hi Allen, if doing a select you need to relate the two tables by the pointer fields. Something like : Select ; table1.field1 as f1,; table1.field2 as f2,; table2.field3 as f3,; table2.field4 as f4; from table1 inner join table2 on table1.pointer = table2.pointer; into cursor mycursor. Frank.

Re: relations VFP9 SP2

On Tue, Mar 13, 2012 at 12:00 PM, Allen pro...@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

RE: relations VFP9 SP2

...@leafe.com] On Behalf Of Allen Sent: 13 March 2012 17:00 To: profox@leafe.com Subject: relations VFP9 SP2 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

Re: relations VFP9 SP2

Allen pro...@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

Re: relations VFP9 SP2

Thanks for all replies. I now have an idea for the morning Thanks all Al -Original Message- From: Frank Cazabon Sent: Tuesday, March 13, 2012 6:13 PM To: profoxt...@leafe.com Subject: Re: relations VFP9 SP2 Hi Allen, if doing a select you need to relate the two tables by the pointer