Shopping List with Barcode reader

[mylo1107]

Good evening everyone. I searched on the forum something that would be good for my project but my knowledge is a little 'low and rusty, I do not remember much.




I would like to create a database of Access inserting all the products divided by vendor with its barcode and the remaining amount. At the moment I would like to shoot from a shopping list just down the product codes to be reordered so that the list of the final actual supply can then be created.


I hope I was clear in explaining if anyone can help me or advise me a solution I would be very happy


Thanks a lot in advance

[ranman256]

I would have a tVendor table,
a tProduct table with fields:
ProdId
ProdName
Barcode
VendorID
InStock