Dupe error

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

Re: Dupe error

David Fairbrother wrote:
> 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,

Nevermind, fixed. Thanks.

--
- dcf