Hello, I have a library that contains tables that start with o_ and some that don't. I want to be able to search through the o_ tables for a certain ID, such as where ID = 12345. I then would like to have separate outputs with the rows where the ID is found for each table. The tables are very different in structure so cannot be stacked. The ID field is named the same in each table. For example Need it so when ID12345 is found in tables A,C,D then I get separate outputs for A,C,D with all the rows that ID12345 is in. Next person I lookup could be in tables B,E,F, so I would need separate outputs for B,E,F where that person is found. The number of tables grow each year so I do not want to maintain a list of the tables, just know that they all have the same naming convention. I need all the fields in the dataset to output and not just ID. (Version 8.2) Thanks!
... View more