Create a table occurrence (TO) of the same table that the list layout is based on. Link the list layout TO with the new TO in a relationship matching the table's primary key to primary key.
Then in your footer add any fields you want from the new table occurrence.
Is the data you want to show in the same table as the list view? Or is the data you want to show in a related table?
It's mostly in a related table
It was that easy! Thanks guys!
You actually don't need to filter, or script, or add TO's. The footer in a list view is automatically from the perspective of the one active record. Just like in any other layout part, you can show fields from the active record, fields from records related to the active record, portals of records related to the active record, and so on. No scripting. No new structure. I do it, quite literally, every day.
See my (rather lengthy) post about this here: Re: Divide a layout in colums
from the new TO you to show the active record you can throw in another TO for the related table and then include any fields from that in the portal. Alternately have one relationship from the TO of the layout to the related table that includes predicates in the relationship to only show the related data for the active record (ie. by including the primary key of the layout's TO to the matching foreign key in the related table).
Thanks Chris - never ceases to amaze me how we can forget the simple things and make stuff more complicated than it needs to be. If you asked me what is displayed in the footer I would have said it was the active record, but as soon as I saw the word portal in Keith's question I started thinking TOs! Thanks for the reminder
You both were big helps. I have both fields from the active records and a portal to another tables notes.
I did not know that the footer showed things related to the active record