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

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • In Progress
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 support Tickets, there was text field called "Apt#".  I created a new field called "APT#" which is now a text lookup field.  So when the field "full name" (a text lookup field and relationship to full name on Contacts table) on the table "Support Tickets" selects a customer's name, it will automatically fill in the field APT# in the table "SUpport Ticket".   How do i have the information from the old text field Apt# move the information into the new field APT# on the table "Support ticket"?  Could i have modified the old field "Apt#" to be a text lookup?  If so, wouldn't all the original data in that field be lost?  Thank you.
Photo of Shane Selasky

Shane Selasky

  • 382 Points 250 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of wwdmr

wwdmr

  • 236 Points 100 badge 2x thumb
(Edited)
Photo of Shane Selasky

Shane Selasky

  • 382 Points 250 badge 2x thumb
Thanks. i will take a look into this.