I'm working on an application review form which is intended to work like this:

1) Submitter selects an organizational unit from a drop-down.

2) A repeating collection of fields appears which displays all applications currently associated with that organizational unit.  Also included in the collection are a radio button that allows the submitter to indicate whether the application is currently in use, and a "comments" field that is meant to allow the submitter to let us know if they are experiencing any issues or changes.

3) The submitter can review the form, verify that all the information is correct, and then submit the result to us.

However, I seem to be stuck when it comes to getting the collections to populate/iterate based on what's in our database right now.  Details:

The data regarding these unit/application relationships is coming from a database that uses relational tables. We've constructed a view that includes the columns:

Unit_ID | Unit_Name | App_ID | App_Name | App_Description | App_Dataclassification | App_Lifecycle

...with Unit ID and App ID being a three-digit identifier for the units and the applications, respectively.

This view produces multiple records per unit ID - one record for each application involved.  What I'd like to do is have the collection iterate once per record when a unit is selected.

Right now, when a unit is selected, the unit ID is filling in - but nothing else happens.

The collection on the form looks like this at the moment:

And the lookup rules are set like this:

I'm fairly new to Forms (and this may be a bit of an ambitious project for a beginner!) but can anyone there assist, please?