8 Replies Latest reply on Feb 12, 2012 7:45 AM by brunolalonge

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

    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