This should be really easy but i don't know how to make it work= getting values from other table
Hi i'm triying to create a medical health records for my private practice, it was going really fast until this step, so i appreciate if anyone can help me.
In my diagnostics tab i have a portal to present this data
2. ICD-10 (The code for the diagnostic in number 1)
The diagnostic is selected in the portal from a list of a related table which has in the colum A (Diagnostic ) and in the column B (ICD-10 code)
So i can select my diagnostic in the colum 1 of the portal without any trouble, but i can't make it work that when i choose my diagnostic in the colum 1, the next colum of the portal gets the ICD-10 code and insert it.
From a related table with values on column A and B to be used in select list on a portal to choose enter values, it's needed that when i choose a value of the column A, the value of the column B be inserted in the next field