Hi, I have created a database that is going to be used to create and store quotes. When the quote is given to the client they will come back and advise we have won the job. I then have a button under the quote details that will allow us to convert that quote to a job and add it to the job table.
I have created an append query that activates when the 'Job Won' button is selected. It pulls the data from my tblQuote to my tblJob however i also need the Job_Number that gets created when the button is selected (Job_Number is an autonumber that generates when a new record is created(the append query adds the quote to tblJob)) to be added to the quote record that was just won. is this possible to do under the one query?
Also when the 'job won' button is selected i need it to open another form that will link to the new record in tblJob and allow the user to add additional information about the job to that record that has just been created? below are some screenshots of what i have tried so far but have not been successful.
Many thanks for any help offered!