Form Design - Monthly Cycle

[John]

Hi,

I have a table that includes several fields related to the members of a
club. To be a member of this club, you must pay $30 a month. I created a form
that I can enter a new member and his/her payment. My question is how do I
continue the tracking of the payments for the future months? For example,
suppost someone paid their dues on 10/8/2008, (that means that this person is
up do date for October), now how can I enter the payment once the month of
November reaches. Thank you.

John

 

[Jeff Boyce]

John

"enter the payment" where?

Since we don't have a very clear description of your table structure (or
your form), it hard to offer any specific suggestions.

If your table were well-normalized, it might look something like:

tblPayment
PaymentID
MemberID
PaymentAmount
PaymentDate

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John]

Thank you to both of you.

John

You do it with the following tables:
TblMember
MemberID
<Other fields about a member>

TblPaymentType
PaymentTypeID
PaymentType

TblPayment
PaymentID
MemberID
PaymentTypeID
PaymentAmount
PaymentDate

Create a form/subform where the main form is based onTblMember and the
subform is based on TblPayment. You will be able to enter new members in the
main form. You will be able to enter recurring payments by a member in the
subform. When a member makes a payment, just navigate to the member in the
main form, click the new record navigation button in the subform and enter
his payment in the subform.

Steve