Access 2013 - sequential numbering without autonumber
<p>New to this site and access.
I am trying to create a database to keep track of a master log. Need help with sequential numbering. I currently have the following tables.</p>

<p><strong>PO Table</strong>
  <em>POID</em> - Autonumber(PK)<br>
  <em>PODate</em> - Date/Time<br>
  <em>Supplier</em> - String  </p>

<p><strong>Item Table</strong>
 <em>ItemID</em> - Autonumber(PK)<br>
 <em>POID</em> - Ingeter(FK)<br>
 <em>ItemDescription</em> - String<br>
 <em>Quantity</em> - Integer</p>

<p><strong>MasterLog Table</strong>
 <em>MasterLogID</em> - Autonumber(PK)<br>
 <em>ItemID</em> - Integer(FK)<br>
 <em>PieceNumber</em> - Integer ( 1,2,3 ... etc)<br>
 <em>MFG</em> - String<br>
 <em>Process</em> - String<br>
 <em>Length</em> - Integer<br>
 <em>MfgIDNum</em> - String (ABD123XTY-1234)  </p>

<p>I am trying to automate the data entry of the PieceNumber field. So when you enter a new PO and add items to it, once received. It will add a row to the masterlog table starting at piece number 1 through how ever many pieces we have. We number the pieces based on the items we purchased.(i.e. with Item 1 we purchased 100 pieces. So I would have Item 1 piece 1 through 100.) Then we are able to add the other data to the table. Just trying to reduce some data entry time and avoid some mistakes in the numbering of this field. </p>

<p>Any ideas?</p>