Good day! I'm near completion on a database project that's taken me forever to complete. With the help of so many sample databases here I'm 95% near completion.

Attached is my database for your review and suggestions.

I have an Order Products table which basically holds the name of the product and the product description.

OrderProducts
------------------
ProductID (PK)
ProductName
ProductDescription

Next, I have a table called tblInventory which holds the following fields:

tblInventory
---------------
ProductCode (PK)
ProductID
Barcode
SerialNumber

These two tables are linked in a relationship with other tables. (one to many)

Here's the situation:

I have several pieces of large equipment that I want to rent to a customer. Each equipment has a barcode label attached to it. I will have for example 100 mops but each mop has a unique barcode number.

When I go into the orders form and get ready to scan the barcode I want it to show me in the combo box the Barcode Number and the Product Name. This currently happens. However, when a customer wants to rent let's say 3 mops I want each unique barcode number to appear on the order. Somehow it goes to the first number that's created in the table. I have a funny feeling it has to do with the ProductID but not sure.

So basically it should look like this in the Orders Form:

Product
----------
123456 Mop1
456434 Mop2
956893 Mop3

Unfortunately when I go to the next line like I said and scan 456434 it goes back to 123456.

I also want to add the barcode number to my Orders Invoice Report under neath Product Name but not sure how to do that.

it should look like this

123456 Mop1
456434 Mop2
321398 Dustpan
675989 Aquafina

Any help will be greatly appreciated.



Edited by: tech264 on Mon Oct 29 10:58:23 EDT 2007.