Sort one table by a column in another table

[ekaponkratova]

Good day,

Is it possible to sort one two tables simultaneously by clicking the column in one of them? I tried: to create a copy of the same table and create a relationship - didn't work; created a table with distinct items and create a relationship between it and the main table, and then, use this newly created table as the column in my main table - didn't work. In the screenshot below you see that there are two table which share the same items column. So I want to click the items_code in the first column to sort it and have the 2nd table sorting automatically.

[Anonymous · Accepted solution]

I don't think you can use tables to sort other tables. Would a slicer be useful? One slicer would change both tables simultaneously, however.

[ekaponkratova]

Yes, it seems to be single viable option in this sitation. I guess I should allow only one category to be displayed at the same time, otherwise there is a danger that a person will click on the header and sort the table. Unless, I remove sorting. But no, it will allow removing only one part of the problem but a person would still to scroll all three tables separately.