C
Crispywafers
Hope someone who likes to think/design databases can help me out here.
I dont' know alot about access so I'm just trying to formulate in my
mind how this would have to be done.
I have a school database. We currently use it to track students in
regards to their dismissal time, address, grade, classroom, etc. We
have also based on the students dismissal time and grade been able to
use Access's report feature (and a bit of VB) to autogenerate
trimester tuition statements as a report. Tracking their return and
payment has been done by hand.
This has worked, even if a bit ghetto, for a year or so. However, it
causes problems becaue the school is growing. The school would also
like to somehow have a record of those trimester tuition statements
and track payments in the database.
I have set up tables using access's wizards for "Products", Orders,
Order details, Invoices, and Payments. I've made all the relationships
work. My problem is... the order itself is already known (The child's
dismissal time and grade are already in the student table
records--which is what tuition is based on)...
My question is how should I do this? Do I figure out some way to have
that information automatically entered into the order form. Do I
somehow create buttons that will generate July, March, and December
statements automatically?
Any thoughts? Help?
I dont' know alot about access so I'm just trying to formulate in my
mind how this would have to be done.
I have a school database. We currently use it to track students in
regards to their dismissal time, address, grade, classroom, etc. We
have also based on the students dismissal time and grade been able to
use Access's report feature (and a bit of VB) to autogenerate
trimester tuition statements as a report. Tracking their return and
payment has been done by hand.
This has worked, even if a bit ghetto, for a year or so. However, it
causes problems becaue the school is growing. The school would also
like to somehow have a record of those trimester tuition statements
and track payments in the database.
I have set up tables using access's wizards for "Products", Orders,
Order details, Invoices, and Payments. I've made all the relationships
work. My problem is... the order itself is already known (The child's
dismissal time and grade are already in the student table
records--which is what tuition is based on)...
My question is how should I do this? Do I figure out some way to have
that information automatically entered into the order form. Do I
somehow create buttons that will generate July, March, and December
statements automatically?
Any thoughts? Help?