Forum Discussion
How to filter data in different tables
Hi
I have 5 tables and each is independent of the other. No any connection created among the tables. What I want to do is to search a specific person's different information in these 5 tables via personal ID. How to achieve this? Thanks.
Hi,
You could create a new table with all the different values of the personal ID and then link the ID column to each column of the table where you have the personal ID information.
By doing this and using a slicer with the personal ID of the new table, you could have the information of all the tables for each ID.
3 Replies
Hi,
You could create a new table with all the different values of the personal ID and then link the ID column to each column of the table where you have the personal ID information.
By doing this and using a slicer with the personal ID of the new table, you could have the information of all the tables for each ID.You can use this option:
It allows the user to write the ID number and it will filter the list and it will easy to found the ID he want.
