I have two table, the first table (Asignacion) has “ID” (Key) and “Sub - Instalación” (Label)
In the second table (Control Table) I need to choice the names (Nombre) associated to the ‘Sub - Instalación’ from table 1 . The column have to be a dropdown type (Enum List)
When I select each “Sub - Instalación”, I would like to choice only the names (Nombre) associated.
I put on data validity in “Name” column from “Control Table” valid if = SELECT (Assignment [Name], [Sub - Installation] = [_THISROW]. [Sub - Installation])
I can select the names:
But, I know this is a warning because my “valid if” is wrong. I did not select the key column. I can not change the key in table 1
How I should do this for avoid the warning? What is the best way to do?