Value list not working

[john9210]

I’m trying to enter values from a value list based on a calculation field.

Specialists::ActiveSpecialists is an unstored text calculation field. The value list ActiveSpecialists reads values from this calculation field.

On a new records layout the VL is attached to the Prescriptions::Specialist text field so I can select a name from a drop down list.

However, on newly created records, when I select a name, it does not enter into the field. The field remains blank.

The source table for the new record layout is Prescriptions.

How can I get the VL to work?

Update: The value list does not work on new records only. That is, when I create a new record and apply the VL the field remains blank. However, the VL works fine on previously created records.

 

 

Edited March 16, 2020 by john9210
Add latest info

[mr_vodka]

value lists you need an indexed field. Unstored fields are not indexed.

[john9210]

Even when the field is indexed, the value list does not insert values on new records. Strange! I'm using the "All" option for indexing.