>>>>Hi everybody,
>>>>
>>>>I have three simple tables called Software, Hardware, Other which only cDesciption and iActive_Flag fields not to count ID field. I have one form with 3 grids close to each other for these tables maintenance.
>>>>
>>>>Now I'd like to be able to print a 3 columns report for them. Is Excel my only option here? How would I show 1/0 field in Excel as a checkmark?
>>>>
>>>>Thanks a lot in advance.
>>>
>>>Why can't you combine three tables in one cursor and print regular report?
>>
>>Do you mean combining them based on record number (using 3 extra steps)? I thought about it, not sure if this is better.
>>
>>Thanks.
>
>I think - at least in vfp 6 - it's a more than 3 steps
>
>select Id, desc ;
> from table1 ;
> into cursor1 ;
> order by ...
>
>select recno() as xxx, * from cursor1 into cursor cursor1 order by 1
>
>
>
>
>
>
Yes, reading my mind, are you? <g>
If it's not broken, fix it until it is.
My Blog