sort subsummary by other than break field

[OregonKid]

Just been using FM for 1 month, so sorry if answer is obvious. (Using FM 7 on WinXP.)

I have a DB with two related tables - People and Stuff. They're related through a person_ID field. Each person may have zero or more "stuff" records.

I want to create a list report that will give information about a person (e.g., name, address) and then one line under that info for each related "stuff" record. With subsummary I have done that just fine, using the person_ID as the break field.

However, my users don't want the order of the report to be by person_ID - they don't know or care what the ID's are. Rather, the report should be sorted by the LastName field of the People table. I've been unable to figure out how to do this. Any thoughts?

P.S. I've already found LOTS of help by searching the forum archives. Thanks to all of you very knowledgeable participants!

[Vaughan]

Using lastname as a break field can cause unexpected results when more then one person has the same last name. The same goes for any field that may have unintended duplicates. So, create a calc field which concatenates lastname, firstname and ID..

Last_Name & "-" & First_Name & "-" & Person_ID

This will always be unique, no matter what (as long as the Person_ID field is unique). Use this as the break field.