B
Benjamins via AccessMonster.com
Hi,
I have a program to allow the user to allow his client to register a course.
After register for the course, the system will gerenate a list of item that
the user had to pay like the registration fee, the course fee for every month
and a sub fee that had to be paied every year as long as the client still in
the school.
Example of list of item created when the client register for a course form
Nov2007 to Jan2008 and currently is 2008
FeeId FeeType FeeAmt
======================
1 ; RegFee ; $10
2 ; CourseFee(Nov2007) ; $20
3 ; CourseFee(Dec2007) ; $20
4 ; CourseFee(Jan2008) ; $20
5 ; SupFee(2007) ; $5
6 ; SupFee(2008) ; $5
If the year reach 2009
7 ; SupFee(2009) ; $5
will insert be insert into the list
The user will use the item to select that payment the client is making to.
The problem occurs when generating the number of sub fee. The sub fee is
generate base on registered year till this year. If the client decided to pay
the sub fee for the future years in advance, the user will not be able to
select as it is not created and we did not know how many year in advance the
client is paying.
How do i allow user to enter the future year sub fee for payment as the user
can only select item that is created in the list?
I have a program to allow the user to allow his client to register a course.
After register for the course, the system will gerenate a list of item that
the user had to pay like the registration fee, the course fee for every month
and a sub fee that had to be paied every year as long as the client still in
the school.
Example of list of item created when the client register for a course form
Nov2007 to Jan2008 and currently is 2008
FeeId FeeType FeeAmt
======================
1 ; RegFee ; $10
2 ; CourseFee(Nov2007) ; $20
3 ; CourseFee(Dec2007) ; $20
4 ; CourseFee(Jan2008) ; $20
5 ; SupFee(2007) ; $5
6 ; SupFee(2008) ; $5
If the year reach 2009
7 ; SupFee(2009) ; $5
will insert be insert into the list
The user will use the item to select that payment the client is making to.
The problem occurs when generating the number of sub fee. The sub fee is
generate base on registered year till this year. If the client decided to pay
the sub fee for the future years in advance, the user will not be able to
select as it is not created and we did not know how many year in advance the
client is paying.
How do i allow user to enter the future year sub fee for payment as the user
can only select item that is created in the list?