Id Order

[Rockin-John]

Hi,


I have a database I created, at present it holds 216 records, some entries have been deleted. I can add new entries with no problems except how they are being stored. IE, After record 209 all new entries are being stored coerectely in the two tables, but not in the form used to enter data all new records 210 to 216 are showing between 204 & 205 and 206 to 209 are showing as lastest entries.
I just cannot resolve this issue, Pease help.

[RuralGuy]

You need to use a query with an OrderBy clause to guarantee the order of the data.

[Rockin-John]

I have had a go at setting it up, but to be honest I have not succeded, could any give me an idea how to.

[RuralGuy]

Use the Query builder. Include all of the fields of the table you want and select which field to sort on.

[Rockin-John]

Hi, Im not sure if you understood my question its the form i am using to enter the data that is in question. when clicked on to last entry it goes to record 209 insted of the actual last entry, when navigating down the list the last entries are between records 204 & 205.

IE: 204, 210 to 216, 205 to 209.

Thank you.

[RuralGuy]

What do you "click on to last entry"?

[Rockin-John]

Hi, The last record button at the bottom of the page. it goes to record 209.

[RuralGuy]

So you have the native Nav Buttons turned on then. The Jet engine that returns records treates tables as a "bucket" of records and returns them optimized for speed unless you use a query to set the order of the records.

[Rockin-John]

ok, so there is nothing wrong, if i create a button to find last record would this be better.

[RuralGuy]

Is there something wrong with using a query?

[Rockin-John]

not if it can be embedded to operate automatically when database is opened, if so how can it be embedded. Because when creating the query using the wizard forms did not show and as stated previously the two tables are in the correct order.
(I do have querys that calculate tax years, just to let you know that i do use querys)

[RuralGuy]

I'll state it again:

The Jet engine that returns records treates tables as a "bucket" of records and returns them optimized for speed unless you use a query to set the order of the records.

[Rockin-John]

Ok so what you are saying is the only way to view the records in order is in a query and the form stays as is.

[RuralGuy]

Ok so what you are saying is the only way to view the records in order is in a query and the form stays as is.

Bingo! By jove I think you've got it.

[Rockin-John]

Well thanks for your help, case solved and will be marked as solved.
I cured the problem by saving it as is and renaming the file, when opened it was all in order again.
Again Thanks.