Conditional values with auto enter properties.
I am trying to build a DB of hospitalized patients, and I would like to have a field with auto-complete properties, based on a value list, to insert the main diagnosis (example: syncope). On the same layout, I want another field that would auto-enter the corresponding code to that diagnosis (in this case: R55).
I have searched this forum, but found only a few, complicated sugestions. I tried to reproduce This method (http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists%20to%20create%20a%20conditional%20value%20list), also without success.
Can anyoune help?