duplicate record

[Francisco]

Hey there,

I've a form with some fields. when i fill all fields i want to duplicate
that record x times. How?
I thougt that i can have a independent field where i can write the number of
times i wanna duplicate that record but i don't know o to do it.
Someone?
thanks
Francisco

 

[Tom van Stiphout]

On Fri, 18 Jan 2008 06:29:02 -0800, Francisco

Is that really the best idea? Or should you simply add a Quantity
column to your table? Duplicating records should not even be possible
in well-designed databases. Think about it: what if I duplicated some
Product records, and then in another part of the application I have a
dropdown list to select a Product. The user would see what appears to
be the same product twice. He's rounding up a posse and is going after
you with tar and feathers. This is getting ugly...

-Tom.