>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
Roberto,

Make the index on teh child table have an expression of Division+LastName+FirstName and you will alpha sorting on name within division.