This is pretty straightforward based upon your descriptions. You need a relationship for each field on the Parent table that you want to feed with values from the Name Percent table.
To limit the options you need to create reports in the Name Percent table that match your criteria. You then use those as the Record Picker on the appropriate Parent Form.
Here is screen shot of an example where it is set.
I actually named the Report Picker. You will want to do some with terms 3 and 5 in them to make it easy to identify.
