Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's moving my Recno() ?
Message
From
05/01/1998 19:45:07
 
 
To
05/01/1998 19:13:28
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00069341
Message ID:
00069694
Views:
57
I don't really understand how set skip works, I only know that that's what I need to get what I want.
Example: I have 3 tables. (1)clients (2)addresses (3)e-mail addresses
(Lot of snow birds that have a different address during winter, and also 2 e-mail addresses, but they are
obviously independant of the physical addresses).

What I want to have in my grid is:
Doe, John               Address 1               e-mail 1
**************** **************************     e-mail 2
****************        Address 2               e-mail 1
**************** **************************     e-mail 2

                    or

Doe, John               Address 1               e-mail 1
****************        Address 2           *****************
****************        Address 1               e-mail 2
****************        Address 2           *****************
depending on which order is set (which the user sets by moving the cursor into the appropriate column).

If I only set skip from table1 to table2 and from table2 to table3
instead of from table1 to table2 & table3 and also from from table2 to table 3 I get:
Doe, John               Address 1               e-mail 1
****************        Address 2               e-mail 1
This is all with relation set from table1 into table2 and from table2 into table3
If I set relations from table1 into table2 & table3 (and set skip into both) I get:
Doe, John               Address 1               e-mail 1
****************        Address 2               e-mail 2
Bill




>This is probably totally completely silly, off the mark, blah blah blah, but, ahem. Why do you set skip to table3 from table 2 AND from clients?
>
>...snip
>>The only thing I can even imagine might have something to do with it is the relations:
>>(I'm leaving out all the normal syntax, just to show you the relations)
>>
>>select table2
>>set relation into table3
>>set skip to table3
>>
>>select clients
>>set relation into table2
>>set skip to table2, table3
>>
Bill Morris
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform