Constrain a set based on a record, then show all, then constrain a set based on next unique record.
I'm using generic records for clarity, but imagine a table that includes ID_1>, ID_2 and ID_3 records.
I constrain by ID_1 when I enter my Print Layout.
I then want to constrain that Found Set by each UNIQUE number in ID_2.
So out of 100 records, the first 50 have a "UUID1" as their ID_2, the next 30 have "UUID2" and the last 20 have a "UUID3")
I need to set the first ID_2 record as a local variable, constrain by it and then print. (This is where I have gotten to so far)
Then I need to show all ID_2 records again, grab the next Unique ID_2 number, and constrain by that, then print.
Then grab the next UNIQUE UD_2 record, and so on until the end of the Found Set.
Does that make any sense? Anyone have any thoughts? Every example I come across doesn't work for one reason or another. Nothing I can find fits this scenario.