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).
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.
