AnsweredAssumed Answered

Linking Data in Two Separate Fields

Question asked by ScottMarwin on Nov 8, 2014
Latest reply on Nov 9, 2014 by philmodjunk


Linking Data in Two Separate Fields


I'm an orthopaedic surgeon and I've created a surgical data base. The fields are designed for "searchability". For example, I have a field called "Diagnosis" and a field called "ICD9" which is the billing code for a specific diagnosis. I kept the fields separate so that I can search by diagnosis or by code. But, I would like the appropriate code to pop-up in the code field when I enter the diagnosis in the diagnosis field. This makes for ease of data entry. I could avoid memorizing codes for each diagnosis. Therefore, I would like to link each code to its appropriate diagnosis. I'm looking for a solution