Nested For Each command to list grouped data
For every record in a table, many times we want to list their related records in another one, but only for those records that have related records. In summary, we will try to list data in a table, grouped by a certain criteria; this is known as control break.
Read the video script here.
First, we recommend watching the video "Simple For Each command and nested For Each command to list related info"
In this video: order clause for grouping, defined by clause for modifying the base table.