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
or
Doe, John Address 1 e-mail 1
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
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
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