This feature is a great one to implement the minute you purchase FileMaker Pro 10. You can drastically beef up the value of table views by adding sub-summary parts – lots of them. This feature is so good that I plan to add about 20 table view layouts to my own Studio Manager product.
Here's what you usually get in Table view:
In this example, the table is sorted by Filename which doesn't have a sub-summary on the layout. I tried adding a sub-summary above for the Drive field, so when I sort by Drive by clicking the Drive column heading, I get this:
I then added a sub-summary above for File Type and then a sub-summary below to allow me to show a record count. When I click the File Type column heading which causes a sort by File Type, I get this:
The layout I created looks like this in Layout mode:
I like this a lot because all I had to do was create this layout which takes about 5 minutes max. And I have multiple views based on the column my user clicks. This is browsing your data! This empowers the user. If your data is such that you really need multiple sorts to occur, you may need to add buttons for your sorts in the footer area.
Finally, the thing I like most is that I can do this with a single layout that is not complicated or hard to figure out. No tricks to remember or stacked fields or anything like that.
One more thing: the Modify Button. The user gets to add or remove fields to his or her view when he wants without going into Layout mode. Removing fields is especially great. You don't want a field? Just uncheck the checkbox:
Notice that you can add fields from here as well by clicking the plus button. If you do, you get this new Add Fields dialog:
This is ease of use folks! [Continue to: Part 2]