Table fields not updating from form/query entries | Access forum

Dear BestSTL

(Please see accompanying screen shots sent in email to info@stl-training.co.uk)

I'm having trouble getting tables to update properly through a query (or through the form that uses the query). I know it has something to do with the type of table relationships and whether the query Recordset Type is set to Dynaset or Dynaset (Inconsistent Updates), but I can't see a consistent pattern.

According to the Access book I have, a query that encompasses more than two tables should have Recordset Type set to Dynaset (Inconsistent Updates) allowing data entry in any table. I was having just that problem: I couldn't enter data through a form using a large query, until I changed Recordset Type to Dynaset (Inconsistent Updates), then it worked fine (I think). I then changed all my queries Recordset Type to Dynaset (Inconsistent Updates) ... well, why not?

More recently I've split & reorganized many tables and it's through this I've noticed some problems with data not being written to tables properly.

Trial 1 (a query with one-to-one relationships only, Dynaset (Inconsistent Updates))
One query has a table (TBL_STORES) with only one-to-one relationships to many other tables (see Query Trial 1 query.gif). If I open the query and enter a new store, filling each field for the new record, all seems to work. When the query is closed and reopened, the record with the new store exists (in the field StoreName), but any field belonging to a related table is blank. When going to each of the related tables, the information I entered is there, but the Store_ID is missing, so there is no link back to TBL_STORES.

Trial 2 (a query with one-to-one relationships only, Dynaset)
Using the same query with Recordset Type set to Dynamic, and entering a new record in all fields, all works fine. So much for Dynaset (Inconsistent Updates).

Trial 3 (a query with multiple relationship types, Dynaset (Inconsistent Updates))
Another query has a table (TBL_STORES_Contacts) with different relationships to other tables (see Query Trial 2 query.gif). I created a new record and tried to enter values in every field ...
Problem 1. As soon as I tab out for the record I'm faced with the error "The field 'TBL_STORES_Contacts_AddressLine2_ID' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field"
Problem 2. Filling each field for the new record (except AddressLine2) all seems to all seems to work. When the query is closed and reopened, the record with the new contact exists but any field belonging to a related table is blank. When going to each of the related tables, the information I entered is there, but the Contact_ID is missing, so there is no link back to TBL_STORES_Contacts

Trial 4 (a query with multiple relationship types, Dynaset)
I created a new record and tried to enter values in every field ...
- It's not possible to enter anything in the field AltTel or AddressLine2
- When the query is closed and reopened, the record with the new contact exists but any field belonging to one of the five related tables on the left, is blank. Fields in TBL_STORES_Contacts_Addreses are populated correctly

How can I make this all work reliably?
Many thanks for any help as I have serious problems with data potentially being lost at the moment.
Joe