Record Number

[tarlachmoorhouse]

If I open a form based on a table or set and set it to be sorted on a field, the record number shown in the tool bar will show the row number of the record in the base table rather than position of that record in the current sort, is this correct behaviour or am I missing some thing.

eg.

if my table has (user_Id is an auto-increment field

user_id Name
0001 John
0002 Charlie
0003 Stan
0004 Ben

If I sort on name then when I open the form and use the arrow buttons to move through the records the numbers on the box would be

4 -> 2 -> 1 -> 3

Can I set the toolbar to show the order in the sort rather than the order of the base table, so users setp through 1 -> 2 -> 3 ->5

(I realise I could alternatively create my own set of buttons etc)

Thanks

John

[Keith Hubert]

RE: Record Number

John,

You can create your own Menu Bar or put buttons on the form to move from one record to another. The customer ID Code has nothing to do with the record No as the ID could be anything.

Hope that gives you some ideas.


Keith Hubert
Guild Member
London.

[Al Buchholz]

RE: Record Number



John Moorhouse wrote:
-------------------------------
If I open a form based on a table or set and set it to be sorted on a field, the record number shown in the tool bar will show the row number of the record in the base table rather than position of that record in the current sort, is this correct behaviour or am I missing some thing.

That's normal behavior. It's showing the record number of the table. By changing the display order, the record has not moved in the table, so the number hasn't changed.

eg.

if my table has (user_Id is an auto-increment field

user_id Name
0001 John
0002 Charlie
0003 Stan
0004 Ben

If I sort on name then when I open the form

Do you have an index for name? I'd use that rather than sorting (using the order property of the form). If records are changed, added, or deleted the index will be kept up to date.

and use the arrow buttons to move through the records the numbers on the box would be

4 -> 2 -> 1 -> 3

Can I set the toolbar to show the order in the sort rather than the order of the base table, so users setp through 1 -> 2 -> 3 ->5

The records display in the sorted order. Why does it matter what the record number that displays on the toolbar shows?

(I realise I could alternatively create my own set of buttons etc)

That would eliminate the record number confusion for the user. The alternative is to train them to understand what it is rather than what they think it is.

Thanks

John