>Cross-tabulation will allow you to make following transition:
>Source Table structure:
>1. ZoneName1
>2. ZoneName2
>3. Fare
>i.e. you have three field records:
>z1 z2 35.80
>z2 z1 35.80
>z1 z3 67.00
>z3 z1 67.00
>z2 z3 15.00
>z3 z2 15.00
>etc.
>
>Output Table structure, if you use ZoneName1 as rowfield and ZoneName2 as columnfield:
>1. ZoneName1
>2. z1
>3. z2
>4. z3
>.... depending how many distinct ZoneName2 you have in source table
>i.e. you have cross-field filled by fares
>Zone Name Z1 Z2 Z3
>Z1 0 35.80 67.00
>Z2 35.80 0 15.00
>Z3 67.00 15.00 0
>
>Is it what are looking for?
Ok... I guess I can fill in the data with 0.00. See, I don't know what the fares are until the user fills in the grid. But I could put 0's in to start.
To get the input table I can join the zone table with itself, as someone else (sorry, bad with names) suggested.
Ok, getting there. But I still don't know how to call the program. It's a class, so I don't think I can do: "do vfpxtab with input_table". Or can I?
Thanks,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only