Link between two tables

[jeevays7]

Hi all,

I have a tables like below.

Name	Opening price	End price	Difference
A	10	20	Check
B	20	25	Ok
C	30	50	check

the above table has a difference column. it is showing as check if the difference (Opening and end price) is greater than 5.

so i need when i click any Check in the above table the link should go to the another table.

the linked table is below for the Name of "A".

Name	Opening price	Credit	End Price
A	10	10	20

so when i click the check in a first row  it will trigger to the link table.

Please suggest any idea's....

[jpar0511]

From what I can see:

Why don't you just link or join one table with the other table. After that you don't use "Check" as a result if the difference is out of limits but something like
'Credit: ' & Credit

to show the Credit Value?

[jeevays7]

Hi Partikel,

First i need summary and then if i click it will go to the explanation table.

so i need this and i have use some calculations in front end to assign "check" or "OK" in difference column.

[jeevays7]

Hi all,

anyone has any ideas about it??

[Kushal_Chawda]

Please elaborate more on your requirement.

What is the underlying data and what output you need?

[sateeshkumar]

Try once as below or share one sample doc.

First, link those two tables in data model. then, in straight table to use font format to to display in underline. Now Go to document properties->Triggers-> field level trigger on field->on select-> set variable.

if(Getpossiblecount(Dim1)=1 and getpossiblecount(dim2)=1, Var1)

in value give it as 1.

Create second table and provide conditional show if(Getpossiblecount(Dim1)=1 and getpossiblecount(dim2)=1 and Var1 =1.

So when user clicks on underline value it will trigger and display new table.