5 Replies Latest reply on Jan 24, 2012 10:48 AM by philmodjunk

    auto-numbering lists and calculations returning questions marks...thoughts?

    ijontichy

      Title

      auto-numbering lists and calculations returning questions marks...thoughts?

      Post

      I use filemaker to generate scan lists for film projects and I recently encountered an error.

       

      Normally, when I have my found set the first item on the list gets numbered 001 and then the rest follow suit, (002, 003) via the following formulation called "edl_work_EVENT_NUMBER_FORMATTED

      Right ( 1000+ (If (Get(RecordNumber)=1; "1" ; GetNthRecord (edl_work_EVENT_NUMBER_FORMATTED;Get (RecordNumber)-1)+1)) ; 3 )

      storage options are set to recalculate as needed.

       

      Anyway, about 100 or so events into a list like this, I suddenly start getting question marks instead of numbers.   

       

      Any thoughts as to why?

       

      As always, appreciate the great help this forum affords and am a fan of PhilModJunk especially.