New record using existing data
I'm needing ideas on how to create a new record using existing data. Example I have many proposal records, that sometimes turn in to jobs. I have a table for jobs and a table for proposals. Usually when i create a new job record, i am re inputing in alot of duplicate data. Fore example Client ID Job Location, Price of Job. Can anyone give me some ideas, or tips on creating a easy interface to turn a proposal in to a job record? Something like a button to create a new job based on proposal Number. I'm up for all Ideas Thank you in advance.