I have a form that has a collection (Funding Accounts). The Reason Code field in the collection is a drop down box ( values of 1,2,3,4) another field in that collection is an account number from a lookup that is being assigned to the selected value of the dropdown box.
Now, Below that are four more tables (RC1 - RC4)
In RC1 need to display the account number collected from the collection which is assigned Reason Code 1
i'll repeat this for RC2-RC4