AnsweredAssumed Answered

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

Question asked by MaximePaquette on Apr 17, 2012
Latest reply on Apr 19, 2012 by CamelCase

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'

Outcomes