I would argue that duplicating information is exactly the wrong thing to do.
Proper normalization results in a minimum of duplicated data. I'd urge you
to reconsider your data model.
That said, it is not always possible to redesign the database.
Yes, it is possible to duplicate multiple records at the same time, or
rather, you could do so sequentially in code so it would look as if you did
it all at once. However, the best way to do this depends a lot upon the
specifics of your database, of which you have given none.
Can you elaborate a little?
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L