Report page change after matching records

[Lala]

Hi - I have a simple database with two tables, household and household_members. There are two forms, a browse and edit for entering households and an edit form (used as a subform in the household form) for entering household members. The tables are joined household.household_id to household_members.mem_household_id.

On browse, when you click on a household, you can see the head of the household, and all of the members of the household.

The aim of my report is to be able to print out all the households with the household at the top of the page and the members listed in the detail area. I don't seem to be able to get just the relevant household members on the page. In the SQL I have tried different types of joins but to no effect. Can anyone help? Database backup attached.

01-27-2025_210652_6798037c15e02_nuBuilder_backup.sql.gzip

[steven]

Hi Lala,

Try putting the house in the top section eg.

group1.png

This way you won't need to group your SQL statement.

group2.png

And you'll get this...

group3.png

Steven