Copying fields from one table to another.

[Guest]

I would like to code a command button that when clicked it will copy a field
from table tblRates to the table tblJobs. I have a table that contains the
rates which need to be save with the job so that when the rates changes the
old job rate will be preserved. An append query will not work for my
application.

The form that I am working from is frmJobs and the table is tblJobs and the
field I want to have the rate placed in is JobSEP. The table that contains
the rate is tblRates and the field is SEP.

 

[G. Vaught]

If I understand you correctly it would seem that frmJobs is based on the
tblJobs and when you enter the rate to the field JobSep, that information
comes from the tblRates SEP field I assume from a drop-down.

Now when you change the tblRates, this rate will change the rate currently
written in the JobSep field of the tblJobs and this can't happen. What you
need to do is copy this whole record out to a separate table unless you
create a field to capture the original value at the time of the order that
is not linked to the rate table. In other words at the time of the order you
would copy the rate to this field and would not get changed. Thus if later
the rate changes you still know the original rate the customer received.

I think copying the record out would be the safer way to go. It would serve
as an archive of the original order.

 

[Frank]

I don't enter the rate into JobSEP, I want to grab the rate SEP in tblRates
and place it into tblJobs into the JobSEP field.