>I am trying to "append" a new record into a table...however, I would like it to be inserted into the middle of the table instead of the end. Is this at all possible? TIA :)

There is an old but still available mechansim to do this (the xBASE variant of INSERT), but it's very expensive to use - better to maintain position using an index rather thanshifting physical record positions.

The syntax for the xBASE variant is:

INSERT [BLANK] {BEFORE]

BLANK is equivalent to APPEND BLANK, inserting the record immedately after the current record in the table

BEFORE specifies that the new record precedes the current record.