title: MS access : how to add 1 row between 2 rows?
body: <p>I have an access database with these tables: 
  - sequences: it describes the sequences of a movie : ex: boy kicking ball (1) , boy hitting ball(2), boy speaking(3) etc..</p>
  
  <ul>
  <li>movie: it is composed of sequences above.
  ex: 3 - 2 - 1 - 2</li>
  </ul>
  
  <p>My problem is : how can I insert a new sequence because access always inserts it to the end.
  ex: I would like to get (I would like to insert sequence 3 between 2 and 1)
  3 - 2 - 3 - 1 - 2 </p>
  
  <p>and Access will give me 
  3 - 2 - 1 - 2 - 3 (added to end)</p>
  
  <p>Any clue ?</p>