4 Replies Latest reply on Jan 19, 2012 6:59 PM by tbcomputerguy

    Relationship based on a global field

    sparrowsfall

      Title

      Relationship based on a global field

      Post

      I'm trying to create a relationship with a global field on the left side.

       

      i.e., if the global field contains 1 (numeral one), a portal would show all related records that have 1 in the target field.

       

      FileMaker won't let me do it. I get the little "T" endcap in the relationship pane (which, by the way, is *not documented* in the FileMaker docs).

       

       

      According to this:

       

      Note: A relationship can utilize a non-indexed field (such as a global field or a calculation based on a global field) as the match field for the relationship, so long as it is on the 'current file' side of the relationship only. In other words, the related match field must always be indexed, so the relationship cannot be based on a global match field on the right side of the Define Relationships dialog box.

       

      http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=3402&p_created=1115172713

       

      It should work. I'm using the global field on the left side of the relationship, with a simple number field on the right side.

       

      FM 10.0v3 in Snow Leopard.

       

      Any help?

       

      Thanks,

       

      Steve