john9210 Posted March 14, 2020 Share Posted March 14, 2020 (edited) 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted March 18, 2020 Share Posted March 18, 2020 value lists you need an indexed field. Unstored fields are not indexed. Link to comment Share on other sites More sharing options...
john9210 Posted March 18, 2020 Author Share Posted March 18, 2020 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1471 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now