I'm working on a solution for a friend's small business.
: I created a table that stores a list of the FileMaker tables within the database for this solution.
I'll refer to this table as a foundation table. I've also created a list form to show the different table names listed in the foundation table.
: How do I create a calculation field within the foundation table that counts the number of records found in each of the other tables by the table name stored in the foundation table?
Thus far, I've attempted the following and I'm not getting accurate record counts.
- fnd_tables - foundation table name.
- table_names - a field within the fnd_tables table
- xc_recordcount - a calculation field within the fnd_tables table that contains the following syntax:
LECT count(*) FROM FileMaker_Tables WHERE BaseTableName = ?";"";"";table_names))