0 Replies Latest reply on Jul 5, 2012 3:06 PM by DavidJondreau

    Value List behavior change on conversion

    DavidJondreau

      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?

       

      Thanks,

      David