(Msg. 1) Posted: Thu Oct 09, 2008 3:02 pm
Post subject: Form Design - Monthly Cycle Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Thu Oct 09, 2008 4:39 pm
Post subject: Re: Form Design - Monthly Cycle [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
"John" <John RemoveThis @discussions.microsoft.com> wrote in message
news:214D5873-A0D9-4848-9D9D-AE4E70F8C61B@microsoft.com...
> 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
(Msg. 3) Posted: Thu Oct 09, 2008 8:21 pm
Post subject: Re: Form Design - Monthly Cycle [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You do it with the following tables:
TblMember
MemberID
<Other fields about a member>
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" <John DeleteThis @discussions.microsoft.com> wrote in message
news:214D5873-A0D9-4848-9D9D-AE4E70F8C61B@microsoft.com...
> 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
(Msg. 4) Posted: Sat Oct 11, 2008 10:01 am
Post subject: Re: Form Design - Monthly Cycle [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <John DeleteThis @discussions.microsoft.com> wrote in message
> news:214D5873-A0D9-4848-9D9D-AE4E70F8C61B@microsoft.com...
> > 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
>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other