I am having a State/City/Area setup in Address table which I am referencing in another table using ValidIf and it works fine. User selects State from the dropdown and then the City field shows up, selects City and the Area field shows up. All of the fields provide a dropdown for the user with the values from Address table.
My requirement is rather than showing the values in dropdown in the State field, user is required to enter the state name and with that the City dropdown comes and then the Area dropdown.
Is there a way, free text or numeric id can be allowed in a Ref field (Enum) using ValidIf with the referenced values from State column in this case (from Address table) being not visible to user?