I believe the new Conditional Break feature in Designer 7.1 can help you solve this problem. It'll let you specify an expression which compares the previous value of the section_name field with the value of the current instance of section_name and, if they're different, insert a page break to the top of the next page.
Assuming the basic structure inferred by the Data View palette when you drag & drop the options node onto the form, make the page subform Flowed (using the Content property Object palette's Subform tab), make the options subform repeatable (using the Object palette's Binding tab) and then go to the Object palette's Pagination tab on the options subform. There, you'll see a middle section labeled
Conditional Breaks with an Edit button that'll be enabled. Click on that to set an expression like this (in FormCalc):
options[-1].section_name ne options.section_name
where the Break property is set to
Before and the To property is set to
Top of Next Page.
The result will be a form which lists each section on its own page without have a superfluous blank page.
I've attached a sample form based on your sample data which breaks whenever the state changes.
Stefan
Adobe Systems
