Null value on form problem <beginner> Please Help!

  • Thread starter Thread starter Mark Hanley
  • Start date Start date
M

Mark Hanley

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
 
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.
Click to expand...

That's the problem.
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!
Click to expand...

Include BOTH fields - or, rather than basing the Form on a query
joining the two tables, base the Form on the Pupil table (which I
presume is the "one" side table) and use a Subform based on the SEN
table; use UPN as the master/child link field.
 
Back
Top