Here is what happens:
I generate a coupon with a bar code on it.
I have a computer with a bar code scanner - it scans the coupon directly into the access database as a simply number or text. If the number is there, it marks the record as true.
Then next time someone tries to redeem same barcode the database provides a dialog box stating already redeemed.
This time I need to mail the coupons out and when they are redeemed, I want the database to CREATE a RECORD with a field (simple ascii) for the number and a field marked TRUE.
Can you do that? Yes or NO - I need to do it right away.