New entries are not getting sorted automatically

[Guest]

I am using MS ACCESS database for our small prototype project. We divided
table into subtables and entries in these subtables are in ascending order.
Sroting is done based on value of one of the column. The problem I am facing
now is, when I try to add new element to the table (subtable), new entry
which i just added sits on top of the subtable (instead following sorting).
Please let me know whether there are any database settings to over come this
issue.

 

[Nick Coe \(UK\)]

In akumar typed:

I am using MS ACCESS database for our small prototype
project. We
divided table into subtables and entries in these
subtables are in
ascending order. Sroting is done based on value of one of
the column.
The problem I am facing now is, when I try to add new
element to the
table (subtable), new entry which i just added sits on top
of the
subtable (instead following sorting). Please let me know
whether
there are any database settings to over come this issue.

I'd bet you're looking at the tables directly, or have no
indexes (keys), or a form with no order by...

I'm not at all sure I understand exactly what you mean by
sub tables, I can interpret that a couple of ways...

If you have a table with child table(s) then you really
should use a Form/Subform to view, add and edit the records.
If it's one table that you're arbitrarily splitting into
groups, then you should normalise the data or use a
continuous form based on a select query which orders the
data the way you want.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----

 

[Andi Mayer]

I am using MS ACCESS database for our small prototype project. We divided
table into subtables and entries in these subtables are in ascending order.
Sroting is done based on value of one of the column. The problem I am facing
now is, when I try to add new element to the table (subtable), new entry
which i just added sits on top of the subtable (instead following sorting).
Please let me know whether there are any database settings to over come this
issue.

You don't have ANY order in a table, if you want it ordered you have
to use a query like:

SELECT * FROM MyTable ORDER BY MyOrderField

 

[John Vinson]

I am using MS ACCESS database for our small prototype project. We divided
table into subtables and entries in these subtables are in ascending order.
Sroting is done based on value of one of the column. The problem I am facing
now is, when I try to add new element to the table (subtable), new entry
which i just added sits on top of the subtable (instead following sorting).
Please let me know whether there are any database settings to over come this
issue.

A table HAS NO ORDER. This is by design; it's an unsorted heap of
records (well, it has an order, but the order is arbitrary and
uncontrollable).

If you want to see records in a particular sequence, you must - no
options! - use a Query to sort the records. Such Queries are
updateable, and can be used as the basis of a Form.

I'm concerned that you're "dividing the table into subtables" - do you
mean you have multiple Tables with the same structure? If so, please
reconsider: you'll be MUCH better off having one table, with a field
to distinguish the categories. Again, you can use a Query to select a
"subtable" of records out of the table, simply by putting a criterion
to select one set of records.

John W. Vinson[MVP]