AnsweredAssumed Answered

Need through relationship

Question asked by ChrisJohnston on Nov 20, 2015
Latest reply on Nov 24, 2015 by 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

Outcomes