Enum list with ref show empty list

[avishai_goldis]

hi, i trying to use enumlist bash on table.
1. 

2. employee table:

But in the Enumlist. the list is empty..

Thanks 🙂

[avishai_goldis]

Please 😞

[Totocoss]

Is employee_id the key in your employee table ?

[Markus_Malessa]

It is very hard to tell what you are doing and what your expected result should be. It looks like maybe you are trying to establish a self-relationship within the same table, and at the same time trying to set what I presume is your key column [employee_id] as a REF column also. Unfortunately that is not how this would work. If you are trying to set employee to manager relationships then you need an additional column for [manager_id] that would be of type REF, assuming each employee only has one manager, or it could be EnumList type REF if an employee has multiple managers but it should probably still be employee to manager vs manager to employee.

[AleksiAlkio]

When using Enum or EnumList base of Ref, you need to have a formula either in the Valid_If or Suggested values. It can be as simple as Table[KeyColumn].