Custom user autonumber
<p>I have been searching for a solution to this autonumber problem that I am having. There seems to be no definite answer anywhere.</p>

<p>I have a form which has a text field. </p>

<p>I want this form to display the next number from a field in a table.</p>

<p>Example: the table contains 3 records with the values D001, D002, D003</p>

<p>The form is used to enter new records (new data). So next time I enter data I want D004 to automatically show up on the text field for data code in the form.</p>

<p>How can this be done?</p>