0

Table Builder - filtering on Secondary Table

Andy Gates

October 02, 2018 19:01

Answered

Follow

Table Builder seems to permit creating a filter on a Secondary Table. Is this correct? It's not filtering the results so I wanted to confirm it is possible. Thanks.

• Facebook
• Twitter
• LinkedIn

2 comments

• 1
  
  Harry Lewis October 08, 2018 14:05

  Hello Andy -

  Yes; let's look at a simple example.

  Let's suppose that I want a list of customer balances for all customers who had any transaction in January.

  I would set up my filter (being sure that I defined the filter on the secondary table) and would also make sure to only include records from my primary table only when a corresponding record in my secondary table was found:

  

• 0
  
  Andy Gates October 08, 2018 14:14

  Thanks for the explanation. That is what I was missing!