AnsweredAssumed Answered

How to show a count of total records of a related table in a layout?

Question asked by brunolalonge on Feb 11, 2012
Latest reply on Feb 12, 2012 by brunolalonge

Title

How to show a count of total records of a related table in a layout?

Post

I have two tables, one containing inventory items and the second containing the the locations of the items for wich I added a relationship. I would like to build a layout showing the total number of items AND the total number of locations. I tried adding a calculation field in the inventory table = count(location::serial), serial being a unique key in my location table. All this returns is blank eventough there are 7 unique ID items in the table "location".

 

I tried looking through the forum but can't find what I'm doing wrong.

 

Thanks for any help

Outcomes