Hi - I have a query that is made up of several tables, some of which are linked fields so that change the value of other fields (for example, select NJ and New Jersey pops up in a corresponding field; select CT and Connecticut appears in a corresponding field, etc.).
I set the form to Dynaset Inconsistent (as I understand I am to do because the query is made up of multiple tables), however, when I do so the fields that have linked tables (i.e. NJ and CT) no longer update the corresponding fields.
Do I "need" to do dynaset inconsisent? If I remove this, the problem is solved (although I am fearful it may create other problems). Or is there a way to maintain the integrity of the linked tables/corresponding fields?
A sample attached