Page breaks based on field value?

[JSRunnels]

I am making a database to deal with member information. The data is stored in two major tables -- families and individuals. I want to print out pages for the members/families to check and update their information. The family data prints out one record per page. There is significantly less information for each individual in that family. It currently prints out 3 per page. Is there any way to get a page break at the end of each family? So if there are six members, I get a page and a half, next family has one member, printed on a page by itself, next family 2 member gets own page, etc.

Otherwise, I have to take a pair of scissors to it and staple little 1/3 page forms to the family form...

[Ender]

Add a Sub-Summary by FamilyID part to the layout. In this part definition, specify a page break before each occurance. When the Member records are sorted by FamilyID, the part will appear, adding a page break between each family.

[JSRunnels]

Thank you. I knew it would be easy, but I am very new at this and it just wasn't obvious. The only problem now is that it divides them up perfectly, but seems to put some random blank pages in there. It's not a huge problem -- I can always toss those. It just seems strange...

[Fenton]

Blank pages are usually caused by a field, part or some object which is going just over the page break. To you it looks like nothing, but there was something there. Look carefully at your layout to see if you have extra space at the bottom.

Also, you could probably benefit from using "Sliding Up." It's kind of tricky. But with Note fields, etc., it makes a big difference.

In Help there is a whole page on "Removing Blank Spaces in Printouts," somewhere in the Printing Records section. Generally you select everything to slide; as anything can stop it.

[JSRunnels]

I am not sure I want sliding, because the whole idea is that (at this point) A LOT of the fields will be blank. I am trying to print "forms" for members to update their information. By definition, a lot of the fields are currently empty -- for data we have yet to collect. I could just print a blank form I suppose, but my plan is to send each family a form with the information we DO have, so they can double check it.

I will look at the form and see if there is something hiding there, but it seems to print a family of six (2 full pages) just fine. One member - fine. Two members - followed by a blank page. Wierd. If it ends up being to difficult to track down, I will probably go the lazy route and just pull out the pages. After all, I hope only to need to print these ONCE. It is just my nature to ask why? when something isn't working as expected.

[Fenton]

The reason is twofold. First, I'd set the Subsummary part to "page break before each occurance". FileMaker is smart enough to not put one in front of the 1st.

The second reason is that the Subsummary and Header take up room. Everything is just too big. When I delete the Header (unecessary), make the Subsummary 12 px, and the Body 240, it fits fine on 1 page. You could probably make it a little bigger.