Values from Value List missing, when sorted after second value
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.
A list with *ALL* values from the first fields, sorted after the second fields.
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.