Two dependent table visuals

[Mallikarjun_P]

Hi, 

I need help in displaying table based on row selected in another table. Please find details about my requirement.

I have a database table having 20+ columns, some key columns are "Order Details" "Schedule Status" and "Finance Status"

I created a table visual (TV-1) which shows only 3 columns "Order Details" "Schedule Status" and "Finance Status". 

When use select a specific "Order Detail" in the Table Visual (TV-1) I want to show all the details from 20+ columns for the selected "Order Detail" in another Table Visual (TV-2)

I also want to disable the Table Visual (TV-2) when no row is selected in TV-1. 

How can I link Table Visual (TV-1) and Table Visual (2) 

[lbendlin]

You cannot do that with a single table.  Either create a shadow copy of the table (ie duplicate the query) or normalize your data into a proper data model.