I have a similarly conceived add-in to that produced by Doug: http://www.gmayor.com/ManyToOne.htm. This one does allow the use of a field to provide the subject. From your description you would use one to one mode.

Doug will no doubt be along soon to discuss what is possible with his version.