2 Replies Latest reply on Mar 2, 2012 9:32 AM by Sylvain

    One to Many relationships

    Sylvain

      Title

      One to Many relationships

      Post

      Hi guys,

      I'm sure this is going to be an easy one for you guys :-)

      I have a Client table and a Contract table. A single client can have many contracts.(one to many relationship, I can do that)

      How could I get to see only the Client related records when viewing the contracts?

      (in other words, if i'm viewing the client "Acme Inc.", I want to see only the contracts related to this client).

       

      Thanks

        • 1. Re: One to Many relationships
          philmodjunk

          Option 1:

          Use a portal to Contracts on your clients layout to list all contracts records for that client.

          Option 2:

          Use a script that either uses Go To Related Records or performs a find to both change to the contracts layout and also pull up just the contract records related to that client.

          Your go to related records step might look like this:

          Go To Related Record [Show only related records; From table: Contracts; Using layout: "Contracts" (Contracts)]

          • 2. Re: One to Many relationships
            Sylvain

            I think that should do the trick... Thanks :-)