I need to run an append query and update the information on a form
I have a quote table, i enter a quote number, name, description and customer. I want to then go to the jobs form, hit a button, request a new job number, and then ask what quote number i would like to turn into a job. This part i have got ok. then i want it to run the append queries, and put in the quote (in the quote table) to the job form ( which is from the Jobs table). Is this possible?
I have a quote table, i enter a quote number, name, description and customer. I want to then go to the jobs form, hit a button, request a new job number, and then ask what quote number i would like to turn into a job. This part i have got ok. then i want it to run the append queries, and put in the quote (in the quote table) to the job form ( which is from the Jobs table). Is this possible?
