AnsweredAssumed Answered

Constrain a set based on a record, then show all, then constrain a set based on next unique record.

Question asked by pinchvalve on Apr 21, 2014
Latest reply on Apr 24, 2014 by pinchvalve

Title

Constrain a set based on a record, then show all, then constrain a set based on next unique record.

Post

     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.  

Outcomes