It might be easiest not to use a portal at all.
If your table has at least these fields:
Name, Address, City, Phone
You can construct a summary report for your list.
Add a sub summary layout part, when sorted by City, Print above to your layout.
Put the City field inside this sub summary part.
Put the name, address, phone fields inside the body.
View your report in list view after sorting your records by the city field in order to group them by city.
In versions of FileMaker older than FileMaker 10, you'll need to view this report in preview mode in order to see the sub summary parts.
This isn't really an option as there will be hundreds of city markets, and to have hundreds of layouts doens't seem like the right answer either.
Each city record will have information specific to that city.
Unless I am understanding you incorrectly, let me know if that makes any sence.
One layout is all you need and you can perform finds to limit the records to just those you want to see at the same time such as just a single city or all cities in a given county, state, or....
I am waiting with bated breath...
Funny guy. I left it with ... because this is a virtually endless list of possible criteria you can use in your find. It's up to you to figure out what works best for your project.
Cool, I got it to work. Although in order for the City to show (and there as other information as well about the city including other fields) I had to put the city field and the others acssociated with it in the Header. When I put it in the body, it would disappear when I changed to list view. Any reason this may be?
It shouldn't disappear just because you put it in the body. If anything, that should result in seeing the same city name over and over again.
It can disappear if you put it in a sub summary part and then don't sort the records in an order that includes the "when sorted by" field specified in the sub summary part's set up.
Putting it in the header works if you only need to see records for one city at a time. With a sub summary part, you have the option of including records from multiple cities--provided you correctly sort your records by city.
Awesome, thanks Phil.
As always you rule.