<div>
<div class="content wysiwyg-content">
I would appreciate a solution to the following problem:<br />
<br />
I have setup an small Access data with say 300 records. The main table is<br />
indexed by a sequential number (not a counter) that is allocated manually<br />
each time a new record is added.<br />
<br />
What is the easiest way to renumber the main and related tables (one-to-many) when<br />
entering a new record into the range 1-300. For example record 200 exists<br />
but a new entry requiring to be numbered 200 is to be added to the table.<br />
How can it be added with the previous 200 becoming 201 and all subsequent<br />
numbers being incremented by 1.<br />
<br />
(I know this flies in the face of relational theory)<br />
<br />
Any suggestions/responses would be helpful.<br />
<br />
Darren Morris<br />
Supreme Court of Victoria<br />
<br />

</div>
</div>


I would appreciate a solution to the following problem:

I have setup an small Access data with say 300 records. The main table is
indexed by a sequential number (not a counter) that is allocated manually
each time a new record is added.

What is the easiest way to renumber the main and related tables (one-to-many) when
entering a new record into the range 1-300. For example record 200 exists
but a new entry requiring to be numbered 200 is to be added to the table.
How can it be added with the previous 200 becoming 201 and all subsequent
numbers being incremented by 1.

(I know this flies in the face of relational theory)

Any suggestions/responses would be helpful.

Darren Morris
Supreme Court of Victoria



Resequencing Access table records

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.