Normally when ever we are trying to create a Value-List using the values from an unstored calculation field, FileMaker shows a message that says “The Value-List will not work because the field can not be indexed“. If we ignore that message and the Value-List gets created then most of the time it will not display any value if used in a drop-down list..
But there is a simple way to overcome this situation. Just create a relationship to the table which has the calculation field and then use the calculation field from the related table occurrence in the Value-List, also select the option “Include only related values” as appropriate. Now this Value-List will work fine if used in a drop-down list.