I plan to have a text field in each record to capture this reference info; some sources may have data there; some may not; and some data may not be entered sequentially (That is, as the user fills in the form, records 2, 9, and 21 may have a "footnote." Later, more data entry is done, and a footnote is added to record 13.)
Is there a way to autonumber these text fields, the way Word does, so insertion between "footnotes" causes a renumbering?
![Scratch :scratch:](./images/smilies/scratch.gif)
Lastly, would Access 2007 be favored over Access 2003 to accomplish this effort?
Any hints, tips, or pointers welcome.