>>>I expected a little bit more 'modern' solution. Is there any?

Yup, but not necessarily through the RW. Are you sure this is the way you should be creating your output, since it's tree structured?

If you have a limited number of nested levels, as it seems from your brief description of your data model you might have, you can also use an HTML table, or an equivalent Fox cursor, with the columns across representing the levels.

Visualize the organizational chart going sideways, with the "head" at the left, branching out to lower reporting levels to the right.

As soon as you visualize how this table will be laid out, with blank and filled cells, you might get a sense of how you could then report on this cursor in an FRX!

It's not classic tree handling, but it sounds like it might work in your situation.

OTOH, again, there are many "modern" models for tree-structured output that you can use, with a little recursive code (something VFP is very good at).

I usually model the tree in XML first and continue to whatever form of output result is needed from there.

One output format for trees, I particularly like to use is HTML output in unordered lists, because they naturally indent as you move down through levels. There's practically no work involved. Plus, with a very small amount of DHTML script, you can have the tree structure collapsing and expanding at will.

You can also control Visio itself as a COM server, right? Or PowerPoint (I think PowerPoint exposes organizational charts in its object model)? Or MS Chart? ANd then you can print from there.

I hope this gives you some ideas. I personally would go for the UL approach -- remember that at least in IE you can custom-designate bullets with images [wink]! So it can get pretty snazzy and is dead-easy to generate.

>L<