Having an Issue with a Combo Box in a subform
Oct 29 2007, 09:56 AM
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.
Next, I have a table called tblInventory which holds the following fields:
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:
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
Any help will be greatly appreciated.
Edited by: tech264 on Mon Oct 29 10:58:23 EDT 2007.
test.zip ( 197.96K ) Number of downloads: 8
|Go to Top · Lo-Fi Version||Time is now: 19th June 2013 - 09:16 PM|