Is it safe to assume that data is stored FIFO?  i.e., when one adds a record to the database, is it always in the same (relative*) position?  I ask because I've implemented a history database, and I'd like to know if I'm guaranteed to always have an ordered set of records (in time entry order).

(*) By relative, I mean relative to data before and after it.  i.e., if I add record #5 to the database, it's position in the database is relative to the first four records.  If I delete record #4, record #5 becomes record #4 and so on down the line.

Hammer wrote on Mar 5^th, 2008 at 12:16pm:

OK.  One thing I haven't figured out is how to sort sub-records.  Is there a way to do this programatically without relying on a Sort Spec?  I'd like to set it up such that when I bring up my main form, the sub-form records are sorted properly.