>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,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement