How to have a multi select field based off of a report of a seperate table

I am trying to create a multi select field that looks at a report from another table  not just one field. We have  to be able to add the field while ADDING a record so adding a child record is not possible.