2 Replies Latest reply on Jan 29, 2013 1:27 PM by ShaunHamid

    Static Related Found Count

    ShaunHamid

      Title

      Static Related Found Count

      Post


           Is there a means to have a static found count number of total records?  Let me explain what I want to do.

            

           I have a database of records connecting to a number of episodes of a television show.  The database is broken down in tables based on the the portions of the show.  The tables go SHOW->EPISODE->MEDIA.

            

           On a MEDIA layout I have a Get(FoundCount) field which is great as it's dynamic and shows how many records are showing.  What I'd like to do is have static count of the total related records.  So say Episode 1 has 20 media files, however on a report I am showing 16.  The Get(FoundCount) will show a 16, but I would like to show an 16 of this static count(20 in this case).  Get(TotalRecordCount) seems promising but it gives me everything, and I just want related.

            

           Is this possible?  Would it be done with some measure of a TO?

            

           Thanks,

           Shaun

        • 1. Re: Static Related Found Count
          philmodjunk

               IF you have:

               TableA----<TableB

               then

               Count ( TableB::NeverEmptyField )

               Defined as a calculation field in TableA will produce the count of related records in TableB. In place of "neverEmptyfield"  you may refer to any field that stores some kind of value in every record. An auto-entered serial number field or a foreign key field thus make good choices for this.

               Or

               TableB::sCount

               Where sCount is a "count of" summary field that counts a never Empty Field will, if placed on a tableA layout or referred to in a calculation evaluating from the context of TableA, also return the same count.

          • 2. Re: Static Related Found Count
            ShaunHamid

                 Thanks!