Sorting IDs

[abc]

I was asked to maintain a current database..

the previous DBA built an Event ID to track the records..

In other words, when you open the form you see an Event ID (auto) at
the top of the form, but at the bottom of the form you can scroll
through the record IDs..

the users told me the event ID never matched the record ID.. (not sure
why the dba did this)

anyway, the users explained that they were able to scroll back and
forth (using the record id's toggle arrow buttons) and the event ids
would be in consecutive order.. and the record IDs would be in random
order.. they were told to ignore the record IDs..

Problem: The record IDs are now in consecutive order and the event iDS
are in random order..

how do i fix this??

 

[Guest]

I'm not sure what the Event ID & Record IDs are, but I'm guessing the Event
ID is the PK & the Record ID is a FK. Also, it's not clear from your post why
the Event ID should match the Record ID. However, if all you want to do is
sort by the Event ID, in design mode, go to the form's properties. In the
Data tab, use the Order By field to sort your your records in the form:
FormName.[Event ID].

 

[abc]

THANK YOU it works!!!

Is there a reason why its sorting backwards.. starting with the last
record?

 

[abc]

Oh nevermind I fixed it! THANKS!!!!!

 

[Guest]

Your welcome. I'm glad I could help.