By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Populating a table

P: n/a
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

Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

Jun 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.