Records that shift automatically-why?

[Guest]

Hello!
I have recently started to use Access 2003 and started by creating a table
using an existing Excel table. I used a column consisting of consecutive
projectnumbers (proj number 1, 2, 3, etc) to also be the primary key - the
idea being that each record number (as I add more records) would then
correspond to the project number as well.

It does this, but after I tried to add records directly into the table the
table I noticed that the new entries had shifted to record positions 1, 2, 3
even though they were projectnumbers 236, 237, 238... The weird thing is that
every new record seems to be added into record positions at the beginning of
the table instead of continuing at the end of it. This shift in record
position has not affected the automumbering - it automatically steps up by
one as I add new project records.

What did I do wrong? Your comments will be appreciated!

 

[Rick Brandt]

Hello!
I have recently started to use Access 2003 and started by creating a table
using an existing Excel table. I used a column consisting of consecutive
projectnumbers (proj number 1, 2, 3, etc) to also be the primary key - the
idea being that each record number (as I add more records) would then
correspond to the project number as well.

It does this, but after I tried to add records directly into the table the
table I noticed that the new entries had shifted to record positions 1, 2, 3
even though they were projectnumbers 236, 237, 238... The weird thing is that
every new record seems to be added into record positions at the beginning of
the table instead of continuing at the end of it. This shift in record
position has not affected the automumbering - it automatically steps up by
one as I add new project records.

What did I do wrong? Your comments will be appreciated!

Tables in a database have no order. If you want to process or view records in a
particular order you must use a query, form, or report that imposes that order
on the data.