TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
view showing records from indirect related table
Say you have an invoicing database with tables for Products, Invoices, Items, and Customers with the following relationships:

Customers <----- Invoices <----- Items -----> Products

Let's also say I'm on the List All view for the Customers table and want to list all the related records from the Items table join table (an indirect relationship that's two hops away). Currently, the Customers table List All view only shows related records from the Invoices table (a direct relationship that's one-hop away).

Any ideas, please?

Erik Bech
Date Created
11/25/2018 1:20:09 PM
Date Updated
11/26/2018 4:06:21 AM
Philipp Matuschka 11/26/2018 4:06:21 AM
In invoice lines have a ref to invoice which gives you customer Record ID in the invoice line

In Customers do an m:m relationship which gives you all records from invoice line with match conditions Customer Record ID = Customer Record Id
Back to Search Results