2 Replies Latest reply on Nov 24, 2015 6:30 PM by ChrisJohnston

    Need through relationship

    ChrisJohnston

      While creating a database that has Products, Suppliers and Lines I have come across the need to calculate a count of the Suppliers from the context of a Products record. My relationship is like so:

       

      relationship

      My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks

        • 1. Re: Need through relationship
          Extensitech

          ChrisJohnston wrote:

           

           

          My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks

          I'd show a portal of Lines on Products, and then show fields from Suppliers, and a count of Suppliers. This will allow you to add (and show) additional attributes of Lines (full line? partial line? only under certain conditions? From and to dates?) in your portal. You can also more easily spot of you accidentally end up with a second line. Lastly, this gives a handy place for the user to select a supplier on a line.

           

          You can use fields from tables other than the portal's focus, so long as they are "beyond" the portal focus.

           

          Chris Cain

          Extensitech

          • 2. Re: Need through relationship
            ChrisJohnston

            Thanks for the insight, thing are working well with the setup.