Hi all! Is there a way to return a text value of a specific row number in a column of one table, to a specific row number in a column of another table? For example, I have created 2 tables “Personal Details” and “Diagnosis”, and the “Diagnosis” table is referenced to the “Personal Details” table by a UniqueID. If I want the “Personal Details” table to have a column name called “Involved organ”, which is just a text field that cannot be filled by anyone, but will only get filled with either “Liver”, “Pancreas” or “Biliary Tract” words only when I go and select either “Liver”, “Pancreas” or “Biliary Tract” option from a Enum column called “Involved organ” in the “Diagnosis” table, can that be done? Thank you.
LinkedIn
Twitter
