Making relation internally over two tables

[#1]

Hello ,

i have a requirement to select the item from one table , it should make selection automatically on the same item existing in the another table on the same sheet.

I am describing my example here please find this

I have two table objects on sheet,

This is my First table

Table 1

Time

Temp

WC

sec

This is my Second table

Table 2

Time

Percentage

Lots

Sec

I need to get the results as if i choose Time from "Table 1", automatically Time item in the "Table 2" should on select mode.

here Table1 and Table2 both are not having relationship over them.

Can anybody suggest me on this.

Thank you

Regards

Charitha.

[alexandros17]

If you load data as you have written all fields are connected by the field Time that is if you select a Time all the fields in both tables that match the selected time will be returned, as you need.

You must pay attention to the time format

Hope this helps

[#3 · Accepted solution]

i got the result by loading each column in separate manner.