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, 20205 yr by john9210
Add latest info

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

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.