I have a single form layout subform that moves to any record by the record navigators. They are listed by the data and time they were created (Oldest First). One of my clients wants to be able to re-order entries. (typically when some record was missed out or something needs adding in between existing records). Because the current order is date and time I could simply add a pop up form and demand an old date and time that fitted between entries in the existing list. I just wandered if there was a more user friendly approach. Something like a pop up form with a list of the records with a drag and drop feature.
Strictly speaking there is no specific reason to have a date time created field in any record. it was originally the best way I knew to ensure that records were presented in the order that they were created