AnsweredAssumed Answered

Values from Value List missing, when sorted after second value

Question asked by electric_soul on Feb 22, 2011
Latest reply on Feb 24, 2011 by electric_soul

Summary

Values from Value List missing, when sorted after second value

Product

FileMaker Pro

Version

FM Adv Pro 11.0v3

Operating system version

Windows XP SP3

Description of the issue

This is an annoying bug :) And I assume it is a bug. And I cannot find it in the database.

Steps to reproduce the problem

1. Create a table with two textfields. Add some records. The first field must only contain unique values. The other one must contain duplicate values.

2. Create a Value List. First Value is from the field with the unique values. Display second field, and choose the second field. Make sure you sort the values using the second field.

Now, apply a dropdown list to some field and look at the valuelist.

Expected result

A list with *ALL* values from the first fields, sorted after the second fields.

Actual result

Due to the fact that the second field does not contain unique values, Filemaker simply removes all duplicate lines.

So, the list does not contain all values from the first field.

Outcomes