Listing associated Sub records with the main Row replication

(My post from last week got deleted so I am trying this again…)

Hi Community,

I am trying to show a list of Award records from my Nav database, along with a list of all associated Sub Award No's. One Award could have zero, one, or multiple associated Sub Awards. Assume these are in a different table linked thru the Award No. (key) and I know how to link and grab those associated records.

So I set up a row replication NL(Rows,Award,…) and then columns 1-10 are just pulling simple fields from the Award table. That worked fine. Now I would like to also show a list of associated Sub Awards right next to each "master" row.

So first I thought it would be nice to show them as additional columns at the end of each row. So I tried to set up a column replicator in column 11, so that each associated Sub Award would show up as an additional column (11, 12, etc) as if it was part of the row (Award) record.

This kinda worked except: if row 1 had three associated sub awards, and row 2 only had one associated sub award, the extra two column values at the end of row 1 would be replicated onto row 2 and higher… Is there any way around this? Maybe a command that "ends" the row replication at a certain column cell?

Then I also tried adding another row underneath the original NL(Rows), but after the replication, all these additional associated rows go to the bottom of the list. So I didn't have any luck that way either.

Basically I am trying to figure out how to pull a list of master records using a row replication, and show a list of associated (linked) records from a different table, next to each one of those master records.

Any help or advice is greatly appreciated!

Thank you
Bobby