I'm hoping someone can help me out with some rather basic php...
It's a complete n00b question I know but I've spent the last 30 minutes or so trying to find what I want on google but have had no luck finding exactly what I want.
Basically I'm trying to make a simple web app which will track products serial numbers as we sell them. I've created a MySQL database with 5 Tables (Administrators, Products, Requests, Staff, Users).
Administrators - people who can add/remove products from the 'Products' table
Products - a list of products using the UPC (barcode)
Requests - where all the information will get scanned in (product being sold, who it was sold by, serial number of product sold etc)
Staff - just a simple list of staff who requested the product which is used to populate information in the Requests table
Users - users who will gain access to the system to add requests for each sale
My basic plan is to scan the products barcode and have it autocomplete information such as the part number and product description on the requests page. At present we're using drop downs in MS Access and for staff members we're typing their name in which is resulting in a lot of inconsistency which my undiagnosed OCD doesn't like
At the moment all I've really got is the database set up and am just looking for help setting up the auto-completion part.
Any advice is hugely appreciated
Thanks