Show table 2 only when one row in table 1 is selected

Giddyap — Mon, 21 Mar 2022 14:00:38 GMT

Dear Sirs

I have two straight tables. They're linked properly and work fine as parent/child. Table 2 (child) shows details from one row in Table 1 (parent).

However, when NO rows in Table 1 are selected, Table 2 is irrelevant and messy, as it shows details from all the (non-selected) rows in Table 1.

How can I make Table 2 show details ONLY when ONE certain row in Table 1 is selected?

Thank you.

Kind Regards

/Morten

Re: Show table 2 only when one row in table 1 is selected

Anil_Babu_Samineni — Mon, 21 Mar 2022 14:06:29 GMT

In Table 1, If you have plenty of dimensions, Please create Composite key and the composite key you can use in condition.

Ex, In table 1 you have F1, F2, F3 ...

I would prefer to create it F1&F2&F3 as Key

And in Table 2, Add on I will use like

If(GetSelectedCount(Key)>0, 1, 0)