How do i move data from one field to another automatically?

I am making my company's forms to be more relationship based rather than everything being a simple text field.  I built a relationship between two tables called Support Tickets and Contacts.  On suppo...