Roger Gill
asked on
MS ACCESS PROBLEM !!!
Building simple MS ACCESS database.
Creating invoice but its not working.. I think I am screwing up in relationships. Attached you will find simple database, please let me know if I would have done this differently.
We are the institution hires examiners and tutors for student. Examiners and Tutors Charges us certain amount( every Tutor or examiner charges different) and the we charge our students ( that billing part i still have to work on) I am stuck in very beginning.
Thanks in advance
MYDATABASE.accdb
Creating invoice but its not working.. I think I am screwing up in relationships. Attached you will find simple database, please let me know if I would have done this differently.
We are the institution hires examiners and tutors for student. Examiners and Tutors Charges us certain amount( every Tutor or examiner charges different) and the we charge our students ( that billing part i still have to work on) I am stuck in very beginning.
Thanks in advance
MYDATABASE.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hnasr thanks for the advice, Mr. :John Tsioumpris than alot taking time to solve this question for me. I was able to close that particular small project. Thank alot Mr. John...
ASKER
Mr. :John Tsioumpris thanks alot taking time to solve this question for me. I was able to close that particular small project. Again Thank alot Mr. John
Glad i helped you..
Use Invoices for table and also for form. You may use tblInvoices frmInvoices if you prefer.
To whom the invoice will be sent, it is not obvious from the table>
IDInvoice InvoiceDate InvoiceAmount PaidAmount Balance
1 5/4/2018 $0.00 $10,000.00 $0.00
2 5/5/2018 $0.00 $0.00 $0.00
3 5/8/2018 $0.00 $0.00 $0.00
4 5/7/2018 $0.00 $0.00 $0.00
5 5/10/2018 $0.00 $0.00 $0.00
6 5/11/2018 $0.00 $0.00 $0.00
Spend some time in building the right structure before building more objects with a weak structure.
Start with an invoice as it is printed on paper, then follow the normalization process for the database. (Search for database normalization).
This will help you in building the right relationships that will simplify data retrieval.