WHY I need to duplicate records in a table with a primary key.

[Roe]

Thanks for the responses!

For example, I have a suppliers table with unique
supplier numbers (primary key field). I want to
duplicate certain records and assign a temporary, yet
sequential supplier number to the duplicated record, so
that there will be no duplicates in the primary key
field.

The reasoning behind this is, I have many suppliers with
the same exact information; only a couple of fields will
require alteration once a desired record is duplicated.
The application I'm working with is being used for data
entry. All these actions should all be performed through
a form where the data is entered from.

Here's another spin on the situation... There are other
tables with data related by the supplier number. I would
also like to have this data duplicated upon duplication
of the data in the supplier table.

Thanks.

 

[TC]

Please do not create a new thread for this!

Stay within the original thread (where I have already answered this).

It gets hopelessly confusing for everyone, if you start a new thread to
continue an exsting conversation!

Apart from anything else, the new thread might be seperated from the
original thread by *hundreds of other new threads*.

HTH,
TC