You should never make any assumption about the physical order of records in
a table: tables are essentially "sacks of data", with the records fitting in
wherever they can.
If the order of records is important, you need to ensure you have a field
(or fields) in the table that can be used in a query to sort appropriately.
If chronological order is what you're after, add a CreatedBy field to the
table, and set its default value to Now.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Bob Z" <sstorme[ at ]comcast.net> wrote in message
news:lbSdnY-jQs52rp_YnZ2dnUVZ_qCdnZ2d[ at ]comcast.com...
[Quoted Text] > Win2000 pro - Office 2000
> After entering data using a form - getting out - and returning - I find
> that
> the records are out of order.
> I have a generated primary key - the key does not show in the correct
> order.
> When I look at the table - It is not in the correct primary key order.
> Any
> thoughts?
> Thanks
> Bob
>
>
|