Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Tables interacting with each other

Hello all

 

I have 2 tables on my report, both looking at different aspects of the same data.

 

Table 1 looks at an address and a date on which they contacted us.

 

Table 2 has multiple columns showing why they contacted us.

 

Currently when i select an address in Table 1, Table 2 changes to reflect only the contact that the selection in Table 1 refers to.

 

I would like Table 2 to show all contacts from that address when I select an address in Table 1.

 

For example:

 

Table 1

Address             Date (UK)

123 Fake St        1/11/2019

124 Fake St        2/11/2019

125 Fake St        3/11/2019

123 Fake St        4/11/2019

 

When I select the first 123 Fake St record, Table 2 updates to show:

Address            Date               Reason

123 Fake St       1/11/2019      Oranges

 

Whereas I would like it to show:

Address            Date                 Reason

123 Fake St       1/11/2019        Oranges

123 Fake St       4/11/2019        Pears

 

How can I achieve this (bearing in mind I have to keep the 2 tables separate)

 

As an extra bonus, I would love Table 2 to show blank until a selection in Table 1 is made if that is also possible?

 

Any help would be appreciated.

 

Daniel

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Dont you have a key that you can relate between the tables?

     

    BR,

    DR

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

     

    What does Table 2 like? if just add the additional column "Reason" based on Table 1? Is the relationship established between them?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello both

       

      Probably should clarify, when I refer to Table in ym example above, I mean the table visualisation. All the data for both visualations comes from 1 table.

       

      v-diye-msft Anonymous