Are you trying to do this manually or build a function to do it? How do you
want to actually select the records?
Me, I would build a form that allows me to select the primary book, maybe a
dropdown list. Then select the related books, probably in a subform with
checkboxs bound to a boolean field in the main table, and then have some
code on a button that ran a query to copy those selected into the second
table. Last thing would be to clear all the flags.
That was a quick thought. probably flawed but you may get the idea.
Jeff
"More Access Stuff."
http://www.asken.com.au
"zazu" <mi***********@gmail.comwrote in message
news:11**********************@o11g2000prd.googlegr oups.com...
>I have a table listing books including a 13 digit ISBN. I have a
linked table with five colums which is used to display five similar
books to those listed in the main table. The ISBNs listed in the
linked table are all in the main table. Instead of inpputting the
similar books via a subform can i automate the process - and in bulk.
In other words can I randomly select five ISBNs from the main table
per ISBN and put them in the linked table