AnsweredAssumed Answered

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

Question asked by ijontichy on Jan 24, 2012
Latest reply on Jan 24, 2012 by philmodjunk

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.  

 

 

 

 

Outcomes