Hi There
I have a one to many relationship between two tables:
tbl_Tutor and tbl_Tutorial - one tutor can give many tutorials
but this logic doesn't seem to work when it comes to data entry forms
I have created a form using the wizard in Access to allow a tutor to enter information about each tutorial.
This is made up of fields from tbl_tutor and tbl_tutorial (the fields from tbl_tutorial are shown as a subform on the main form)
When I go to enter a new record via this form it brings up a 'null' error.
Here are my table details if any of you can see anything wrong with the fields:
tbl_tutor
TutorID - NUMBER
TutorName - text
Telephone - text
Email - text
tbl_tutorial
TutorialNo - AUTONUMBER
TutorID - NUMBER - linked to tbl_tutor by this field
StudentID - NUMBER - linked to tbl_student
Date - date/time
Notes - text
TutorName - text
TutorID seems to be the problem field from my limited knowledge of databases but perhaps there is a better way of trying to achieve the outcome I need.
Any help appreciated!
I have a one to many relationship between two tables:
tbl_Tutor and tbl_Tutorial - one tutor can give many tutorials
but this logic doesn't seem to work when it comes to data entry forms
I have created a form using the wizard in Access to allow a tutor to enter information about each tutorial.
This is made up of fields from tbl_tutor and tbl_tutorial (the fields from tbl_tutorial are shown as a subform on the main form)
When I go to enter a new record via this form it brings up a 'null' error.
Here are my table details if any of you can see anything wrong with the fields:
tbl_tutor
TutorID - NUMBER
TutorName - text
Telephone - text
Email - text
tbl_tutorial
TutorialNo - AUTONUMBER
TutorID - NUMBER - linked to tbl_tutor by this field
StudentID - NUMBER - linked to tbl_student
Date - date/time
Notes - text
TutorName - text
TutorID seems to be the problem field from my limited knowledge of databases but perhaps there is a better way of trying to achieve the outcome I need.
Any help appreciated!
