It seems I can't code my way out of a paper bag.. I am, however usually good enough with google to find what I want but I keep finding the wrong information
I'm hoping some of the ajax/php gurus out there can help me out a bit.
Basically I'm trying to make a inventory tracker to scan out products from my warehouse. The idea being that when a product is sold the barcode and serial numbers of the product will be scanned so I can determine exactly what is no longer in the warehouse.
So I've got a 'Products' database with the following fields: ProductUPC (barcode) ProductPartNumber (unique 6 digit code for each product) ProductDescription (description of the product).
On my HTML form I've got a bunch of text boxes (UPC, Part Number, Description & Serial Number).
I want to be able to scan the UPC of the product and have the Part Number & Description fields auto-complete with AJAX/PHP wizardry so that these fields don't need to be entered manually..
Then all that needs to be done is for the serial number barcode to be scanned and boom the results end up in the 'Requests' table
Sounds relatively straightforward but I keep getting auto-suggest stuff for the one field
Any help is hugely appreciated