I need to create a summary overview (table) to display the number of records in each table. The numbers should be updated as the data is filtered. I have five tables: A, B, C, D, E, F. The display should look like this:
Any suggestions are appreciated.
Make sure each of your tables have an unique ID field (you can create one with the AutoNumber() family of functions if it doesn't exists) so you can use count(distinct ID) to find out the number of records on each table.
How can I restict the number of tables that are appearing? For example, I might have 10 tables in the model, but only want to show 5.
Also, the number of rows needs to change as the data is being filtered.
I think I have a work around. I created an inline table to show the table names that I want to display. I create a chart (straight table) and used a calculated expression to count the key for each table.
It works, but is there a bettter way?