OK, I have now implemented a submission form as you suggested above and it works perfectly, except that I don't get the Multi-select option. What am I missing here?
And now my next question is how do I create a link to that submission form in the Lender Search and Report Details Page above and have the Lender data automatically get entered in to the 3rd table ( MSA_Offerings)?