3 Replies Latest reply on Sep 26, 2013 6:05 PM by keywords

    relationships

    coherentkris

      Ok i just read thru a post about relationships from 2008 from another site http://fmforums.com/forum/topic/57413-relation-graph-cardinality-question/.. good information from Comment and David Jondreau. Basically they said that in the relationship graph the straight line indicated relationship to an auto enter field or a validated unique field. The crows foot indicates a "normal" relationship and the pipe indicated a match with an unindexed field (unstored calc, forced to no index, or global) matches that involve a non global pipe are not resolved and a portal based on the relationship is empty. The one instance where the pipe can resolve is to a global. This is true even when their are globals on both sides of the relationship. I used two globals in several tests and it works.. my questions is this... in the real world what possible use is their for a match between two globals?

      TIA,

      Kris

        • 1. Re: relationships
          coherentkris

          No takers?

          • 2. Re: relationships
            Stephen Huston

            This used to be done all the time (prior to the introduction of the X relationship joins) to make all records in one table related to all in another table, or to allow the on-the-fly turning on or off valid relationships via user-entered info in the globals.

             

            The only instance where this might still be a useful solution would be with a global on the parent side being filled in by the user or some user-based action to temporarily create a join to another table.

             

            The X-join relationships (cartesian join: all records in Table A joined to all records in Table B) has replaced the other instances of this practice with globals, AFAIK.

            1 of 1 people found this helpful
            • 3. Re: relationships
              keywords

              Just a clarification on the following:  The crows foot indicates a "normal" relationship

               

              This is not quite accurate; "normal" is a bit misleading. Relationships are generally described as one-to-one, one-to-many, many-to-many, etc. These are represented in the relationships graph as follows:

               

              single line = one

              crows foot = many

               

              so a relationship that has a single line at one end and crows foot at the other is one-to-many, etc.

               

              The rest of the discussion concerning the pipe is right—it indicates an unindexed field at that end of the relationship, nicely described in one post as a roadblock.

              1 of 1 people found this helpful