How to Navigate from Table to another sheet

[#1]

Hi

I have a Straight Table with different fields.

each field has a specific sheet.

Now how can i navigate to that respective sheets by clicking on each fields.

for better understanding:- please see the attachment

Please come with a Solution As soon as Possible

Thanks,

Dileep.

[Nicole-Smith · Accepted solution]

Settings > Document Properties > Triggers > Field Event Triggers > [Company Name] > On Select > Layout > Activate Sheet

Then in the Sheet ID box:

=pick(match([Company Name], 'Test1', 'Test2', 'Test3'), 'SH01', 'SH02', 'SH03')

You need to replace the 'SH01', 'SH02', 'SH03' with the sheet IDs from your .qvw file (the same goes for the company names).  What I have above is just an example.

[#3]

Its Working Fine .

Thankyou Smith.