Newby question

[deke]

Hi. Total newby here.

I created a database with some products and barcodes. Each barcode is different from another, so I used it as my primary key. All information about these products are in this table.

When I sell these items, I scan the barcode numbers and make a list (packing slip). All I get from this scan is the barcode number. How can I use this list of barcode numbers to make a packing slip to include the information from the other table. Could someone point me in the right direction, or maybe what search words I should use to find the appropriate thread. Thanx

 

[MyBoo]

Without additonal information:

You could create an "Package Table"... which would hold nothing more than the the barcodes you scan for a particular order. It would have a one-to-one relationship with your products table. Create a query, based on both tables that lists the barcode from the package table and all other information from your products table. Create a report based on this query. Your report would be your packing slip. You would then create a delete query to delete the records in the package table... this would remove the like items from your products table.

One problem with the above is that you have no history. Once you delete a packing slip, those products are gone. If I were doing this, I would capture my invoice# and sales date and then move all invoiced items to another table. This way, I can, over time, identify what I sold and when as well as be able to reprint my packing slip, if ever the need came about.

 

[deke]

Thanks for the help. OK, I am going to give this a try.