I have a data entry screen that is giving me the following error when I try to save a record."field studentinfo.personid cannot contain a null value because the required property is set to true."
this makes sense because the particular field IS set to required. but it is a FK from an autonumber.
the screen collects person information (addresses, etc), student information (programs, etc), and assigns a role as a default value (student). There are no subforms, everything is on main form.
My recordsource for the form is:
Expand|Select|Wrap|Line Numbers
- SELECT studentinfo.*, person.*
- FROM (person INNER JOIN studentinfo ON person.personid = studentinfo.personid) INNER JOIN tblperson_role ON person.personid = tblperson_role.personid;
Expand|Select|Wrap|Line Numbers
- SELECT studentinfo.*, person.*
- FROM person INNER JOIN studentinfo ON person.personid = studentinfo.personid;
tblPerson: personid (pk) - autonumber
tblStudentInfo: studentinfoid (pk) - autonumber, personid(fk)
tblPerson_Role: personid(fk), roleid(fk)
tblRole: roleid (pk) - autonumber, role