Creation and display of song setlists
Below is a possible approach you may want to consider. It's using &quot;State&quot; names (like Florida, Illinois, etc.) instead of &quot;Set 1, Set 2, etc&quot; and &quot;Cities&quot; instead of &quot;Songs&quot;.
If I was to implement this in a Drupal site, I'd use either of these &quot;displays&quot;:

Option 1 - Master detail with nested blocks
Have a look at this example, which shows 1 &quot;block&quot; for each &quot;State&quot;, and within each &quot;block&quot; it shows the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;.

Option 2 - Report that filters based on some lookup
Have a look at this example, which shows only the data about a specific &quot;State&quot;, together with all the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;. To switch to another state, select the desired state from the Parameter form near the top (&quot;IL&quot; is used as the default in this example).


If you wonder &quot;How did you do that?!?!&quot; ... then this is the answer: that's really a piece of cake using the Forena module. Checkout the Community Documentation for details, and/or the documentation that comes with the module. The above 2 examples are actually delivered with the module (out-of-the-forena-box), though you probably don't notice that it is even not a typical &quot;Drupal database&quot;. It could be such database instead, but in this case it's an SQLite (sample) database (it could also have been Oracle, MS SQL, Postgress or any PDO compliant database).
Disclosure: I'm a co-maintainer of Forena.