2 Replies Latest reply on Jun 20, 2010 4:28 PM by HugoLidia

    Relationship issue

    HugoLidia

      Title

      Relationship issue

      Post

      We have a policies file related to a claims file, for which there can be more then one claim for any one policy, so I figured this is one to many realtionship, but in my policy layout which has a claims portal, every policy that has just one claim is having this repeated unpteen times and the datbase manager reports the relationship as many-to-many. 

      1.  Why?

      2. How do I break the direct link to enable just the one instance of a claim to be displayed in the claims portal

       

      Or am I looking at this incorrectly?

       

       

        • 1. Re: Relationship issue
          LaRetta_1

          If the records in the portal are repeating same information, it points to the wrong fields in the portal or wrong table occurrence for the portal.

           

          So your relationship should be:

           

          Policies::PolicyID = Claims::PolicyID

           

          Be sure the portal is based upon Claims and check the fields within the portal and make sure they all are based upon the Claims table occurrence as well. 

           

           

          • 2. Re: Relationship issue
            HugoLidia

            That is the relationship I have, from Policy table to Claims table, hence my confusion why there is an error.