2 Replies Latest reply on Feb 12, 2009 3:39 PM by comment_1

    Relationship diagram weirdness....

    synergy46

      Title

      Relationship diagram weirdness....

      Post

      Here is a peculiarity that does not seem to have a downside.

       

      I have 2 tables:  Members  and Zipcodes

       

      To enable the user to type in an extended zipcode (ZIP +4) and still have the zip lookup City and State, I have created a Members::Left(ZIP,5) field.  This field is the field in Members that links to the ZIPCODE field in Zipcodes.   And, it works well.  I can type in a 5 digit zip code or an extended zipcode and the Members::City and Members::ST will return the corresponding values from Zipcodes.

       

       


      The peculiarity is that in the Relationships diagram, BOTH the Members and Zipcodes tables show the 'many to many' "crowsfeet" attachment.  

       

       

      Waz up with this? :smileyhappy:

       

      Thanks