The Location sub head can be created with a sub summary part. Do you know how to do that?
The numbering can be done like this:
Define a field in the table that always stores a 1. This can be an auto-enter setting or a calculation field.
Define a summary field as the total of this "one" field. Specify that it comptue a running total and choose the location field as the "group by" field so that the running total restarts with each location. You can then use this running total field to number your report rows.
Hmm, Don't know what i was thinking here. That works, but you don't need the one field as long as you have some field in your table that's never empty such as a primary key field. Then you can set up the summary field to be a running count of this never empty field and use the same group by, running count options I desribed earlier. That works and uses one less field to do so.
Perfect. I am new to Filemaker and didn't know about the summary option. Thanks.