8 Replies Latest reply on Apr 19, 2012 6:45 AM by CamelCase

    Value list not working when using "related values only" from date field

    MaximePaquette

      Summary

      Value list not working when using "related values only" from date field

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Windows 7 and Mac OS X

      Description of the issue

      The values of a value list show as '?' if include only related values and using values from a date field.

      Steps to reproduce the problem

      Create 2 tables, each with two fields: id (number) and date (date).
      Relate both tables with their id fields.
      Create a value list showing only the related record of the other table and show the date field.
      Create some records in both tables.
      Put a field with the value list in a layout.
      Look at the value list in browse mode.

      Expected result

      Should show a list of dates.

      Actual result

      Show only one value: ?

      Workaround

      Set the default language of the date field to 'Unicode'