Inserting a new line

I have the following table:

Item
--------
ID - Autonumber
Name - Text
Amount - Currency


If a user enter info into this table, how can I insert a new record
between other existing records.

Example:

ID Name Amount
1 Milk $3
2 Cookies $4
---------- Insert new record here
3 Meat $10
4 Eggs $3

How can I insert a record between 2 & 3 and get my table reorder so
now my record looks like this:

ID Name Amount
1 Milk $3
2 Cookies $4
3 my new record here
4 Meat $10
5 Eggs $3


Is this possible??


Thanks!

Hi,
Data in tables is always unordered so what you want is not possible. It should not matter at all what the order is because
you can use an Order By clause in a query to sort it any way you like.

HTH
Dan Artuso

"hin" wrote in message ...
I have the following table:

Item
--------
ID - Autonumber
Name - Text
Amount - Currency


If a user enter info into this table, how can I insert a new record
between other existing records.

Example:

ID Name Amount
1 Milk $3
2 Cookies $4
---------- Insert new record here
3 Meat $10
4 Eggs $3

How can I insert a record between 2 & 3 and get my table reorder so
now my record looks like this:

ID Name Amount
1 Milk $3
2 Cookies $4
3 my new record here
4 Meat $10
5 Eggs $3


Is this possible??


Thanks!