By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Null Value in form problem <beginner> Please Help!

P: n/a
I have found similar problems to mine on this and other newsgroups but I
still haven't been able to solve my problem...

I have two tables 'Pupil' and 'SEN' which are related on a field called
'UPN' (unique pupil number).

I have a form which is bound to a query that is drawn from both of these
tables and contains Pupil.UPN but not SEN.UPN aswell.

When I update the form I get the error 'The field SEN.UPN cannot contain a
Null value...'

Can anybody give me a hint as to what I need to do to put this right? I'm
tearing my hair out here!

Thanks.
Mark Hanley
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...
I have found similar problems to mine on this and other newsgroups but I
still haven't been able to solve my problem...

I have two tables 'Pupil' and 'SEN' which are related on a field called
'UPN' (unique pupil number).

I have a form which is bound to a query that is drawn from both of these
tables and contains Pupil.UPN but not SEN.UPN aswell.

When I update the form I get the error 'The field SEN.UPN cannot contain a
Null value...'

Can anybody give me a hint as to what I need to do to put this right? I'm
tearing my hair out here!

Thanks.
Mark Hanley

You haven't given us much of a clue as to what is contained in the table
SEN, what type of relationship is between the two tables and what is the
purpose of the form in question? Are you trying to add a new record? Do
you expect to be able to add records to both tables from this one form?
Sometimes a form which is based on two tables, is not a logical choice for
making additions - have you considered a form/subform combination?
Fletcher
Nov 12 '05 #2

P: n/a
I am trying to add records to both tables using this one form. The Pupil
table holds general student information such as names etc.. The SEN table
holds further information about a student's educational needs.

I have information from each table separated onto two tabs on one form
except that the UPN from the SEN table (the key on which the two tables are
related) does not appear on the form at all.

There is a 1 to 1 relationship between the two tables.

I hope this fills in the picture a bit. Thanks for helping.
Mark.

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bm**********@titan.btinternet.com...
"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...
I have found similar problems to mine on this and other newsgroups but I
still haven't been able to solve my problem...

I have two tables 'Pupil' and 'SEN' which are related on a field called
'UPN' (unique pupil number).

I have a form which is bound to a query that is drawn from both of these
tables and contains Pupil.UPN but not SEN.UPN aswell.

When I update the form I get the error 'The field SEN.UPN cannot contain a Null value...'

Can anybody give me a hint as to what I need to do to put this right? I'm tearing my hair out here!

Thanks.
Mark Hanley

You haven't given us much of a clue as to what is contained in the table
SEN, what type of relationship is between the two tables and what is the
purpose of the form in question? Are you trying to add a new record? Do
you expect to be able to add records to both tables from this one form?
Sometimes a form which is based on two tables, is not a logical choice for
making additions - have you considered a form/subform combination?
Fletcher

Nov 12 '05 #3

P: n/a
Does the defined relationship include Cascade Update Related Fields?
_________________________________________________

"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...

I am trying to add records to both tables using this one form. The Pupil
table holds general student information such as names etc.. The SEN table
holds further information about a student's educational needs.

I have information from each table separated onto two tabs on one form
except that the UPN from the SEN table (the key on which the two tables are
related) does not appear on the form at all.

There is a 1 to 1 relationship between the two tables.

I hope this fills in the picture a bit. Thanks for helping.
Mark.
_________________________________________________

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bm**********@titan.btinternet.com...

You haven't given us much of a clue as to what is contained in the table SEN, what type of
relationship is between the two tables and what is the purpose of the form in question?
Are you trying to add a new record? Do you expect to be able to add records to both
tables from this one form? Sometimes a form which is based on two tables, is not a logical
choice for making additions - have you considered a form/subform combination?

Fletcher
_________________________________________________

"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...

I have found similar problems to mine on this and other newsgroups but I still haven't
been able to solve my problem...
I have two tables 'Pupil' and 'SEN' which are related on a field called 'UPN' (unique
pupil number). I have a form which is bound to a query that is drawn from both of these
tables and contains Pupil.UPN but not SEN.UPN as well. When I update the form I get the
error 'The field SEN.UPN cannot contain a Null value...'

Can anybody give me a hint as to what I need to do to put this right? I'm tearing my hair
out here!

Thanks. Mark Hanley
Nov 12 '05 #4

P: n/a
"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...
I am trying to add records to both tables using this one form. The Pupil
table holds general student information such as names etc.. The SEN table
holds further information about a student's educational needs.

I have information from each table separated onto two tabs on one form
except that the UPN from the SEN table (the key on which the two tables are related) does not appear on the form at all.

There is a 1 to 1 relationship between the two tables.

I hope this fills in the picture a bit. Thanks for helping.
Mark.

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bm**********@titan.btinternet.com...
"Mark Hanley" <mh*****@SpamblocKclara.co.uk> wrote in message
news:10****************@dyke.uk.clara.net...
I have found similar problems to mine on this and other newsgroups but I still haven't been able to solve my problem...

I have two tables 'Pupil' and 'SEN' which are related on a field called 'UPN' (unique pupil number).

I have a form which is bound to a query that is drawn from both of these tables and contains Pupil.UPN but not SEN.UPN aswell.

When I update the form I get the error 'The field SEN.UPN cannot
contain
a Null value...'

Can anybody give me a hint as to what I need to do to put this right? I'm tearing my hair out here!

Thanks.
Mark Hanley

You haven't given us much of a clue as to what is contained in the table
SEN, what type of relationship is between the two tables and what is the
purpose of the form in question? Are you trying to add a new record? Do you expect to be able to add records to both tables from this one form?
Sometimes a form which is based on two tables, is not a logical choice for making additions - have you considered a form/subform combination?
Fletcher

The first suggestion would of course be to put all the student data into one
table - tblStudents. That would solve your problems in one hit. One to one
relationships between tables are really to be used in special
circumstances - perhaps you have implemented user-level security and you
want to hide some sensitive data in one table but let other data be more
visible. Or perhaps you have found a need to use sub-classing.
However I have only found the need to use them once and, by strange
coincidence, this was a database holding student records.

If you really do have a pressing need for this one-to-one relationship, then
by far the easiest way would be to disallow additions in the standard way -
the record selectors at the bottom of the form. Create custom buttons for
this.
Fletcher
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.