Because I need to hide the status bar, I am creating custom buttons and merge fields on my layouts. To obtain the total record Count and found count I created an unstored calc field with the result of text as specified in earlier posts. I displayed this info on the layout in a merge field. This is all working fine.
I am a big believer in using generic code, buttons and merge fields that can just be copied and pasted to different layouts. To my surprise, when I copied the merge field containing the record counts it worked perfectly when the current table was related in some way to the table that contained the calculation fields.
Question: For organizational purposes, I would have like to create the calc fields in a generic table from which all tables would draw this data; however, the calc flelds only generated the correct information when the current table was related to the table containing the calc fields. So my thought was I would locate these calc fields in a table which is related to most of the tables in some way. And address the layouts with unrelated tables separately. Is this a sound approach? Is there something better that I am missing. Any comments are welcome.