fmp

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)

Full Name:

Section B COUPON SALES TO THE ABOVE CLIENT