Is there a way to pass a parameter to the Master - Detail relationship ?

Jenny Oh

6 janvier 2020 20:15

My master table is linked to to the detail table by username.

My detail table has a field called organization which is not in the master table.

I need to filter the report by organization so I have it as a parameter. I attempt to filter the detail table by the organization parameter but ignores that filter.

How should I construct the query to return only records with that organization?

0

• 

  Jenny Oh

  7 janvier 2020 22:03

  The master-detail relationship is only for joining the tables and does not accept parameters. The additional step I did after I filter the detail table by the organizational parameter ; Under Properties, Actions, Filter String, in the filter editor , I add the condition using the relationship: MasterTableDetailTable exists.

  0

Vous devez vous connecter pour laisser un commentaire.