I am setting up a database to keep track of Sunday School Students. I have a table with the father's info, a parent detail table with the mother's info and a table for the students. All three are in a relationship with referential integrity enforced. I have built three separate forms and I want to have one form where I can see the father, mother and students who belong to these parents. I have the father's Form and two sub-forms with the mother and students. When I want to add a New record, it only lets me enter info for the father and mother but not the student. Access tells me I can't create this record because there is missing data in the parent detail table, or the parent table, but there is because I just entered it. Then when I go back to my tables, the parent info is saved even though it said I couldn't create this record, but nothing for the student.