I am trying to figure out a way to fill a drop-down field in a table with multi-line text field values from a different table on the same form.
This is for a credentialing form that uses a lookup to fill a college name based on a college code. I want to take the values input from the lookup in the college name field and put them into a drop down field in another table on the same form. The idea is that the person entering the college codes in the first table will be able to choose the college names provided by the lookup in the drop down.