If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Design - Monthly Cycle
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 |
#2
|
|||
|
|||
Form Design - Monthly Cycle
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" wrote in message ... 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 |
#3
|
|||
|
|||
Form Design - Monthly Cycle
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 "John" wrote in message ... 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 |
#4
|
|||
|
|||
Form Design - Monthly Cycle
Thank you to both of you.
John "Steve" wrote: 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 "John" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|