Adding revisions to purchas orders....

[Danny]

Hello

The company i work for is currently trying to automate our
quoting form through Access. Right now we use an excel
spreadsheet to list our bill of materials and labour
cost. They now want to use access to output a simular to
the excel spreadsheet. So far we are able to pull in the
job specifics. We are using a continous sub form to show
the labour cost and material cost. This works fine. The
problem is when we want to make a revision. I need to be
able to copy everything plus the sub forms info to the
next revision. We are able to copy the job specifics
only, the subforms do not copy over to the new revision.
They want to see the history of the of the quote. The
reason using the sub forms is to have all the information
vissable during viewing and to make edits. I am not sure
if this is the correct method. I am thinking that we may
have to write some VBA.

The job number and revision are linked together. But when
we try to copy all the records to the next rev the sub
forms info does not transfer to the new revision. If this
makes any sense. Hope someone out there has some insight.

Regards
Danny Chrsitie