Null value on form problem <beginner> Please Help!

[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

 

[John Vinson]

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.

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!

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.