Record Count if met specifics from another table?

[Matthew R White]

I have multiple tables in my database, my main table which holds most of my data, and may other smaller tables that hold various other data and link to the main database such as my smaller To Do List Table.

 

I'd like to show the full record count of the To Do List Table as a (running count/number) on my main database table. However, I'd like it to display different counts for different users and specifications, such as Get current user: if matt then show a count of all records that have producer code 3.

 

Whats the best way to do this? I have this count through various portals and filer on the main To Do List Layout, but I can't get it on my main table

 

 

[comment]

While this can be done using FilterValues(), I would suggest you rethink your strategy as explained here:

http://fmforums.com/forum/topic/92782-filter-portal-by-this-calc/?p=426180