Hi:


I am sort of new to VFP, and I ran into this problem with the Report Designer. I have two tables...a divisions table and an employee table. The employee table is the child table of the other one. For example:

Sales
John Smith
William Reed
etc..
Marketing
Paul Smith
Robert Redford
etc...

What i need is for the divisions table to appear sorted, and all the related records within a specific division appear sorted too.. I managed to sort the divisions, but i never managed to sort the employees table. do i need to do something before i call the report? Or do i have to change something on the report?

Any help is appreciated...
Thanx