title: Increment Number OnInsert()
body: <p>I am trying to increase a field number whenever a new row is added to my table. First I created a variable <code>lastItem</code> specified as a Record with Subtype to my Table. Now I created the following Code on the <code>OnInsert()</code> trigger:</p>
  
  <pre><code>lastItem.FINDLAST;
  ItemNo := lastItem.ItemNo + 10;
  </code></pre>
  
  <p>The above code seems not to work on the <code>OnInsert()</code> trigger but works for one row when I enter it on the ItemNo - <code>OnValidate()</code> trigger. </p>
  
  <p>Any ideas how to get an increasing Number on every new row in my table?</p>