Thanks Bill and Paul for your help - everything in my simple warranty database is now working as intended!
Now...I have new records added one row at a time...a user clicks 'add new' to get a blank row, enters the serial number, selects the part number from a combo box, enters the SDN (delivery note) number and enters the SDN date.
That's all great, until despatch have a shipment of 150 units, then it's laborious having to select part number and enter SDN number and date for each row, when they are all the same!
So...I'd like to create a new form 'enter shipment' in which the user selects the part number and enters SDN number and date at the top, only once, then in a text or memo field enters all serial numbers on separate rows (by scanning bar codes, so very quick), then hit 'submit' and the database creates rows in the table for each serial number that has been scanned, using the part/sdn/date data for each.
But, as usual, I don't know how to achieve this, so can someone point me in the right direction?
Cheers, Nige
Tidak ada komentar:
Posting Komentar