Eager for integrity at the database level, I want to restrict data entry to tables only to pre-established lists of values. I need to create a formula column so that it is populated with pre-defined lists of options. My issue is that these pre-defined lists are already stored in separate tables. To refer to those tables via their names, the names were put in a column in the same Dataverse table.
Would you please (based on the below scenario) provide me with the formula expression to be inserted in the column definition.
