Hiya folks,
I'm trying to put together a database for student involvement in school
sport activities. I'm not exactly what you'd call "proficent" in Access,
so my apologies if I'm making some very stupid or obvious error.
I have three tables.
I have Students2, which contains the fields:
Student No (primary key)
Surname
First Name
House
Year level
tblSport, contains:
SportID (primary key)
Sport
Captain
ViceCaptain
tblSportIDStudents2, contains:
Student number (primary key)
SportID
Team
Relationships:
http://schoolsarge.org/studentrelationships.JPG
I'm trying to enter data into a form which is generated by the wizard.
I have selected the fields "Student number" (which is relabelled as
"tblSportIDStudents2.Student number" when added to the wizard) and
"Team" from tblSportIDStudents2.
"Sport" from tblSport.
"Student number" (which is relabelled as "Students2.Student number" when
added to the wizard), "Last name", "First name", "House" and "Year
level" from Students2.
I then tell it to view by data by Students2, as a form with subforms,
and select Datasheet view mode. It creates the form as per usual.
To illustrate what happens I've taken a screenshot
(http://schoolsarge.org/studentserror.JPG) of what happens when I enter
random data. I did this to ensure it wasn't the data that was causing
it. I still get the same error no matter what is added.
I have absolutely no idea what's causing this, and any assistance would
be greatly appreciated.
Thanks,
--
- dcf
