Copying Files ... Replacing ID's

C

ckrogers

Hi! I'm a beginning Access programmer ... and need some help!! I have three
tables related as follows:

Quote Header (Primary Key=[Quote ID]-autonumber) Contains information
about a quote, including [Quote Number] and [Rev. Level]
Quote Items (Primary Key=[Quote ID] & [Item ID]-autonumber) Contains
information about individual items quoted (one Quote Header can have several
Quote Items)
Quote BOM (Primary Key=[Quote ID] & [Item ID] & [BOM ID]-autonumber)
Contains information about the BOM items included in each item quotes - i.e.
purchased component, raw material, molding part, etc. (One Quote Item can
have several Quote BOM's)

I'd like to provide a command button to create a new [Rev. Level] which
would copy all of the items for a specific [Quote ID] in all three files,
replacing the original [Quote ID], [Item ID] and [BOM ID] with the new
numbers.

Any and all help will be appreciated!! :)

Cindy
 
Top