Copy record from one table to another

[debraj007]

Help! I'm struggling over this problem and need either suggestions on the way to accomplish, or a better way to design my tables

I have a customer database that contains the following tables: Quote, Quote Details, Job, Job Details. If a customer accepts my quote, then I would like to copy the information from the 2 quote tables to the 2 job tables as a new job (keeping me from having to reenter the information). Then I can view every quote I've done for a customer, and every job I've done for a customer. Any suggestions?

 

[Rose]

Can you not just make a copy of the table, or is it more
complicated than that? Or do you need to copy the whole
database and delete the parts you don't need? Or export
your tables to a new database?

-----Original Message-----
Help! I'm struggling over this problem and need either

suggestions on the way to accomplish, or a better way to
design my tables.

I have a customer database that contains the following

tables: Quote, Quote Details, Job, Job Details. If a
customer accepts my quote, then I would like to copy the
information from the 2 quote tables to the 2 job tables as
a new job (keeping me from having to reenter the
information). Then I can view every quote I've done for a
customer, and every job I've done for a customer. Any
suggestions?

 

[Rick B]

I would have only one table. I would add a status such as Quote, Accepted,
Completed, Rejected. Or something similar.

Rick B


Help! I'm struggling over this problem and need either suggestions on the
way to accomplish, or a better way to design my tables.

I have a customer database that contains the following tables: Quote, Quote
Details, Job, Job Details. If a customer accepts my quote, then I would like
to copy the information from the 2 quote tables to the 2 job tables as a new
job (keeping me from having to reenter the information). Then I can view
every quote I've done for a customer, and every job I've done for a
customer. Any suggestions?

 

[Rose]

Then Rick B's suggestion of a field for Status would fit
you a lot better.
If you really need quotes and jobs in separate tables, you
can run a make-table query to create a table for all
records where the Status field=Accepted.

-----Original Message-----
Well, I only want to copy one record at a time, that is,

when the customer tells me that they accept the quote, I
want to turn it into a job without reentering the data from
a particular quote. So copying the whole table wouldn't
work unless I can use some sort of code to delete the parts
I don't want...

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting