I am trying to find a cleaner way to Copy data from one table to another.
I have two tables. "Quotes" and "In House Jobs"
Each table has the same exact fields and I want to be able to "Convert" a Quote into an In House Job.
I currently am achieving this by running a script off a button by simply going back and forth to each table and copying and pasting.
Is there a cleaner script I can write that would do this?
Thanks in advance for your help!