Looking for suggestions

[elentz]

I am trying to figure out how to do this.  I need to keep track or serial numbers for products I sell.  There is a common id that links the serial numbers to a customer.  I need to keep track of:  customerid, serialnumber, vendor, datescanned, warrantyinterval.  I will be using a barcode scanner to collect the serial numbers.  Ideally I want to enter all the info except the serialnumber only once per session (session here being the actual time it takes to make all the entries).  I have a MySql table that all this will be inserted into.  The barcode scanner will scan the code and send a "return" to update the field.  Could an array work for all the stuff that needs to be "common" with each new serialnumber that is added?  I don't know.  I am looking for suggestions

 

Thanks for looking

[cunoodle2]

You could have a hard coded array but you may just want to store these "common" variables in a mysql database so you can easily update/change them.

[elentz]

I am sure an array will be needed but probably not hard coded.  There will be a one to many relationship.  Each time we sell a system we need to scan a number (meaning several from 10 - 100) of serialnumbers.  An array with the common info for each serialnumber table entry.  Somehow an array would need to be created and then used for each time a serialnumber is scanned.