Richard, I have a database that has 7 tables.  All the tables have fields in a main form - some fields are required, most are not. When a user starts a new record, I am finding that unless they touch each table (even by inserting a "0" which is the default value) the children tables do not record the record.  Therefore the record does not show up on the form next time it is opened.  My relationships are one-to-one with the ID of a main table related to the ID of all the other tables.

---

Reply from Richard Rost:

It's VERY tricky when you try to get data from multiple tables in the SAME FORM. I strongly recommend using SUBFORMS, which are covered in the next class (Expert 3).