Need a form for entering barcodes

[elentz]

I need a form that has only three fields that will enter data into a Mysql table.  The three fields are a Date, a numeric field that will be a link number used to link the table fields to a customer name.  The third will be an entry from a scanner (barcode).  What I want to do is initially enter the date, then a customer number (would be nice if I could use a dropdown to get this number).  I will typically need to scan several items at a time that I want to enter as single records, each with the date, customer number and then the barcode.  I am doing this with a MSAccess DB and I want to get away from it and use PHP and Mysql.  Can someone suggest how I can do this?

 

Thanks alot

[DyslexicDog]

It sounds like you have a pretty good plan already. You just need to build up the database and possibly import what you already have. You could just use the access database you already have, but I wouldn't recommend that if you are going to have several people using the database at the same time.

[elentz]

I actually have a form that pretty much does what I want except that I can only scan one barcode at a time and then I need to reset the form.  That is tedious, I am looking for a way to mimic what the Access form does.  It is a form within a form that will continously add new records as long as I continue to scan codes and do a CR at the end.  I definitely want to get away from Access

 

Thanks

[DyslexicDog]

You would need to add some client side javascript to support something like that.

[elentz]

Well, so far in my programming skills that is beyond me.  I'll use what I have for now and live in the happiness that I got away from another M$ Access DB that is buggy

 

Thanks for your suggestions

 

Ed