I’d like to build a base to track our produce prescription program. We have coupons with barcodes to distribute to the patients. Ideally I’d like the health worker to use a barcode scanner to scan the first coupon and the last coupon for each patient. Then I need to populate a table of all the coupons distributed within that range for each patient.
I currently have a table set up for “patients” where health workers would assign the coupons. Then I have a table for “Coupons” where I’d like the records to be each coupon code distributed.
Any help in how to do this would be appreciated!