Help creating school fee database.

[goodspee]

Hi

I would like some help into creating a school fee database and the administrator inputs and views the data through a form/application.

So the data I need to view is the Invoice Number, Student Name, Class, Fee Due and Date of receipt.

The most problem that I'm encountering is that for same invoice number there might be multiple students, due to the fact that they might be siblings.

Any kind of help would be much appreciated.

Thanks beforehand.

 

[healey21]

Welcome to the Forum, if I read this right you need to use 2 tables one for the invoice details and another for the students so you can have multiple students against the single invoice number.

Create a Relational Database. Check out one of these YouTube videos. https://www.google.co.uk/#q=create+a+relational+database+youtube

 

[goodspee]

Thanks, will keep you updated....thanks for your help so far.