Hi fm community, 
Thanks for your assistance that helped us compose what we think is a fairly good data base layout; but of course we will hope that you think so too.


QUICK RE/VIEW OF OPERATIONS:
We sell coupons (#ed 1 to 500) in sets of 10 or more to fisher folks who come here for fishing, fun or fellowship. Each time they visit, they drop off a #ed coupon. We mark these as used on our data base. 
This helps us keep a track on the visits and their used coupons; as we offer a refunds of the unused ones. Helps us budget better.


Section A: is relevant client data about them & the coupons bought; if any.
Section B: is the number of ‘#ed' coupons bought.
Section C: is a visual display of ALL the coupons; to color code as: available (green), sold (blue), used (gold).
Section C may be on it’s own, (in the same file/computer) but linked to Section B.
So that we, at a glance can see how things are shaping up.
When Clients visit: they drop off their coupons in a box at residence. 
We would like to be able to mark these tickets # in Section C and have them automatically appear as marked in Section B with auto (modifiable) date.  Q: How do we do this?
---------------------------------------------------------------------------------------------------------------------------------------------
BTW:
We are located in Holland Landing, ON just a hour north of the CN tower, Toronto. 
If you live in the area, let us know; we can possibly get together for a BBQ or if you are visiting, drop in, if you can.
We have a pretty place by the Holland river. 
Our website:  FisHaven.com  Marilyn & Victor 647 834 2046
---------------------------------------------------------------------------------------------------------------------------------------------
QUESTION AS POSTED:

​

Q 1:  How do we check mark a unique numbered coupon (√) in one section (C) and have this info transferred also to THE relevant numbered coupon in another section (B)?
Here are screen shots of our LayOut Format; in order to better relate to our question.
http://www.fishaven.com/fmp.html or dropbox

Section  A   CLIENT REGISTRATION & RECORDS

Please: Refer to text at the bottom of page

Section  C    TOTAL COUPON ACTIVITY (AVAILABLE, SOLD & USED)

Section  B   COUPON SALES TO THE ABOVE CLIENT