I have a database setup to generate information on textbooks. I run an operation that takes used books, sorts them, and sends to a company that rebinds the books. My database is setup so that I scan the book ISBN and access looks up the isbn on a table in my database. If access finds the isbn it then copies the entire row of data (author, title, isbn, copyright, edition, etc) to another table which when complete I use as a packing list and send to the bindery with the books. If the database doesn't find the isbn after being scanned the book is of no value to me and is donated.
My question is.... How do i setup in access so that when i first begin the process and run my macro I can scan a "Lot Number or shipment number" and have access attach this number to my output table for every book that i scan. i don't want to have to scan the lot number each time I scan a book. i would like to scan it once at the beginning and have access know that each time I scan a book it will attach the lot number.
i will need to assign multiple lot numbers to multiple shipments within the same day being that i ship out multiple shipments to different companies daily. I currently use a popup window and a macro to enter the book isbn and have it look in a table for the book information and then append it to another table if it finds the isbn.
How do I use something similar (popup window) to scan a lot number 1 time at the beginning of the process, and have it attach to every book i scan after the lot number is entered?
I added a scree shot of what my database looks like in hopes someone can help.