J
Josh Mikow
I am currently working on a program that will allow us to scan barcodes
for our company.
I have a table that stores the barcode value and the date/time scanned.
My problem is that by using a Primary Key on the table, it limits the
table to having one row for each barcode and date/time combo.
Our end goal is that we can have a way to limit the number of times a
barcode can be scanned into the table each day. Right now, by using a
PK with the barcode value and date, we can only insert one row per day.
We will typically need to do this a few times a day, but I'm not sure
how to limit this.
Any ideas would be great and helpful.
Thanks,
Josh Mikow
for our company.
I have a table that stores the barcode value and the date/time scanned.
My problem is that by using a Primary Key on the table, it limits the
table to having one row for each barcode and date/time combo.
Our end goal is that we can have a way to limit the number of times a
barcode can be scanned into the table each day. Right now, by using a
PK with the barcode value and date, we can only insert one row per day.
We will typically need to do this a few times a day, but I'm not sure
how to limit this.
Any ideas would be great and helpful.
Thanks,
Josh Mikow