Using "Get(TotalRecordCount) to create history Log

[Jerry100]

I've searched the Forums for an answer to this, but didn't find what I need. I have a file with 20 related tables. Each table has a field which captures Get(TotalRecordCount) at the end of the day. I had created a layout which had the name of the table and the field mentioned above and it printed nightly. All worked well. What I have been attempting to do is create an additional table which captures that information. There is no way I can think of to relate it to the other fields because it only contains the date and a field for each table into which I am trying to copy the current value of the field containing the TotalRecordCount. I've tried autoenter with calculation and lookup and it requires global settings which mess up the original field. I've tried a sequence of copy/paste from each table but get blank fields. Anu help would be appreciated. It seems that creating a log of record counts would be a simple bread and butter setup. What am I missing?

[comment]

Global fields are accessible without a relationship. If you had a permanent table holding the layout names of your tables, you could loop between records, going to the named layout, setting a global register to total record count, coming back to the table and creating a log item in a related table. You don't need any fields in the "real" tables for this.