How to show a count of total records of a related table in a layout?
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