Copy a Single Field From Multiple Records & Paste Into Another Table

  • Thread starter Thread starter justinschmidt
  • Start date Start date
J

justinschmidt

I am very much a beginner at access, and can't for the life of me
figure out how to do the following. Can anyone help?

See screen shot here
http://img397.imageshack.us/img397/9584/accesshelp0xg.jpg

I have 2 Tables running 2 subforms

Table 1 (Under Phase Codes)- Contains all Codes X (Phase Code ID) for
Project Y
Table 2 (Under Production)- Contains production rates for Codes X
(Phase Code ID) for the week of MM/DD/YY

I need to figure out a way to automatically copy all Codes X (Phase
Code ID's) for Project Y from a query on Table 1 into Table 2. I only
really need that one field copied, but there will be about 20
autonumbers for every project. So I need to be able to grab 20
autonumbers from 20 different records in the query, and then paste them
into Table 2 into 20 different records.

Production Rates will then be manually entered each week (therefore
each Phase Code ID will have many entries in Table 2, one for each
week).
 
If that doesn't work. I am trying to get a workaround to work, but
cannot figure out how to properly call a main form procedure from the
subform. Any ideas on that?
 
Back
Top