Issue with Combo Box in Rental Database Need Advice

[Technyc2003]

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.

Here's the link for the file

http://www.megaupload.com/?d=FBNOV9KG

 

[lameid]

Sounds like you are storing ProductID instead of something that uniqely identifies the instance of Mop you are talking about. Perhaps you should store serial number? Whatever the Primary key is on the table where all your items are.

 

[Technyc2003]

The issue I'm having is just weird to me for some reason.

I have a product id for each of my machines. However, I have a seperate barcode id# for each equipment.

When a customer comes to rent the equipment I want to scan the barcode number but my combo box won't let me choose more than one.

 

[lameid]

In the combobox, is the controlsource ProductCode? If not why?