Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Sorting IDs

Discussion in 'Information Technology' started by abc, Nov 2, 2005.

Tags:
  1. abc

    abc
    Expand Collapse
    Guest

    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??
     
  2. Loading...


  3. xRoachx

    xRoachx
    Expand Collapse
    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" wrote:

    > 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??
    >
    >
     
  4. abc

    abc
    Expand Collapse
    Guest

    THANK YOU it works!!!

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

    abc
    Expand Collapse
    Guest

    Oh nevermind I fixed it! THANKS!!!!!
     
  6. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Your welcome. I'm glad I could help.

    "abc" wrote:

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

Share This Page