1 Reply Latest reply on Nov 9, 2014 3:45 PM by philmodjunk

    Linking Data in Two Separate Fields

    ScottMarwin

      Title

      Linking Data in Two Separate Fields

      Post

      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