This topic is locked

Suggestions to track monthly payments?

3/12/2008 12:06:49 PM
ASPRunnerPro General questions
S
sleighbor author

Hello everyone,
I am designing an application around a dance school. The school is open for 10 months - September-June. The students pay a monthly tuition. Anyone have any suggestions on how to track the payments? I'm trying to design the table layout and am hitting a mental block. Any suggestions would be greatly appreciated!
Thank you,

Kevin

Sergey Kornilov admin 3/12/2008

I guess you can create Payments table that will store payment amount, date, who made the payment (UserID) etc.
Is that what you asking?

S
sleighbor author 3/12/2008

Hi Sergey,
Yes, that is what I was thinking. Where I get stuck is then creating the webpage to view and edit this table. Each student pays on the first of the month so I need to record and show what month it was paid for. So you suggest creating a table like the following? When I click View for a student it brings up all their info now. I would like to be able to add this to the bottom of that page. How can I bring this table data into that same view?
Thanks,

Kevin
Suggested table design:
Month Payment UserID

September $50.00 1

October $50.00 1

November $50.00 1

December $0.00 1

January $0.00 1

February $0.00 1

March $0.00 1

April $0.00 1

May $0.00 1

June $0.00 1

S
sleighbor author 3/12/2008

I think I got it.

Thanks for the help Sergey.
Kevin

Sergey Kornilov admin 3/12/2008

Kevin,
you can use Insert ASP code snippet function to display the list payments.
See sample code here:

http://www.xlinesoft.com/asprunner/docs/sh...omer_orders.htm

S
sleighbor author 3/12/2008

Great! thanks again!
Kevin

S
sleighbor author 3/12/2008

Hey Sergey,
To use this ASP code snippet do you put it on the master page or the detail page?
Thanks,

Kevin

J
Jane 3/13/2008

Kevin,
place code where you want to see it.