AnsweredAssumed Answered

Second field populates with first field's selection.

Question asked by VincentYoung on Dec 8, 2012
Latest reply on Dec 10, 2012 by philmodjunk


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.