Adding the same record x number of times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a quantity field that if I enter, say, 10,
this would then automatically add the same
record 10 times.

Is this possible, if so, how?
Help would be appreciated
 
Hello

I have a quantity field that if I enter, say, 10,
this would then automatically add the same
record 10 times.

Is this possible, if so, how?
Help would be appreciated
Click to expand...

It's possible, but this is generally A Very Bad Idea. Having ten - or
even two - *identical* records in a table means that you have no
Primary Key, and therefore no way to identify which record is which,
edit them, or delete them.

Could you explain *why* you want to do this? What are you trying to
accomplish? I strongly suspect that a Query will solve your problem
without requiring a mis-designed table.


John W. Vinson[MVP]
 
Back
Top