>When I add a record, the record is appending to
>the database file, however, the first record in the
>database file reflects identical information inputted
>to the new record.
>
>Why is this happening?
>
>Maybe I know, this form that creates the new record
>also accesses other forms for descriptions and
>instructions. I'm using scatter and gather to flip
>back and forth between these forms to add info
>to this new record.
>
>How can I keep the record pointer on the new
>record when switching to other forms? Please keep
>in mind that I browse and create with these forms.
if you're using buffering, the rows you append appear at the beginning of the file because they are given negative record numbers (until they are saved w/ tableupdate)