>Sorry to sound a bit vague there. Allow me to explain how SQL will behave when 2 tables are joined. Suppose there are two tables with 3 records each:
>
>Table X
>a
>b
>c
>
>Table Y
>1
>2
>3
>
>Then by default, a JOIN will yield the following result:
>
> a 1
> a 2
> a 3
> b 1
> b 2
> b 3
> c 1
> c 2
> c 3
>
>And this is achieved by just ONE line of code. Since you are looking at multiplying rows and columns, this might give you a shortcut rather than writing a long program to do this.
>
>Hope this helps!
>Rishabh.
Ok, I see what you mean. This would be for the alternate way, so I don't have to make it into a grid.
I want to try this cross tab thingy first, since it would probably be easier for the users to fill in a grid than a long combination of zones. But this will work if the grid way doesn't.
I've been looking at this "vfpxtab" program over and over and it's way beyond me. Anybody know how to work this thing?
Thanks,
Previous
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