Second field populates with first field's selection.
I have a medical billing DB. There is the principal diagnosis such as appendicitis, then there are secondary dx such as hypertension, diabetes, asthma, etc. I have 3 fields other diagnosis 1,2, and 3. I created 3 tables, other dx 1,2,3. Each table with exactly the same set of dxs, but table name different. For some reason when I choose from OD 1, that choice populates OD1, and OD3 fields. But not OD2 field. Choosing OD 2 field only populates OD2 field as expected. If I choose a different dx in OD3 field, it will change the selection in 3 but 1 is unchanged. I restarted program, reviewed table associations and field associations but I can't figure out why it populates both fields. I have exactly the same setup in the database with a procedure table, but it behaves as expected. Any ideas. Sorry for typos, typing on phone.
thx in advance.