3 Replies Latest reply on Jun 2, 2013 8:52 AM by philmodjunk

    Sequential Numbering Based on a Sorted Find

    ColinJim

      Title

      Sequential Numbering Based on a Sorted Find

      Post

           This seems like it would be straight forward so perhaps I am not doing the right searches.

           I have performed an inspection of a wharf using Filemaker Go to collect data.  The wharf has three sections (East, West and Deck) and we want to report on each section separately. 

           I have a report layout created that will be similar for each section of wharf.  I will provide an example for what I want using the "East Wharf".

           I perform a find on my Inspection data for "East".  I then sort my data based on pile number.  This is the order that I will be reporting on the East Wharf.  I need to number this 'found and sorted' set sequentially.  In an ideal world I could just use my Data_ID but that would be too easy and my boss isn't having any of that.  

           I'm thinking that this may be done through a calculated field using the count function but it seems to me that there must be an easier and cleaner way.

           Thanks in advance.

           Colin