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 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