Firstly, why one more table with only one extra field serial_number in it? You can add that field to the table_items!


string serialvar, barcodevar='ur-barcode';
int quantityvar=2,...