Create a trigger of variable or rocket scince :)

[sona_sa]

Hi,

I have to sheet. In one sheet I have one straight table with one dimension (Customer) and 4 expression. Now i want to click on one customer A and on the Click of A, the trigger should to fire and go to sheet 2 and show the data for one A. but In both sheet Cutomer are coming from different - different tables.

Please help me ASAP.

Thanks.

[ariel_klien]

Hi,

Try to make a key  between the 2 different tables using the same field in both of the tables. (like CustomerID)

then when you select 1 customer in one sheet it will filter this customer in all sheets.

BR

Ariel

[sona_sa]

Done, But I am clicking on one of the expression and then the sheet 16 should be activated and that particulr field value.

Thanks for reply.

[jagan]

Hi,

Try like this

Document Properties -> Triggers -> Field Event Triggers -> Select Dimension -> On Select -> Add Action -> Select Layout -> Activate Sheet and give sheet ID.

Now whenever you select value in the field the given sheet is opened.

Hope this helps you.

Regards,

Jagan.

[rwunderlich]

See attached using a combination of OnSelct triggers and conditional show.

-Rob

http://masterssummit.com

http://robwunderlich.com