Value List behavior change on conversion

Discussion created by DavidJondreau on Jul 5, 2012

In FM11, I could create a value list that pulls from two fields in different tables and only the values that exist in the first table would show.


For example, I have Contacts and Teachers. A Teacher is a 1:1 child of a Contact record and contains teacher-specific info. I made a value list that pulls the ID from from Teachers to store and the Name from Contacts to display. This gives me a value list of all the teachers.


I converted to 12 and now that value list is showing ALL the Contact records and for non-teachers storing null in the field.


Has anyone else encountered this?