1

I have a table Points related to a table Events. The event table contains the fields Point-ID, Event type and Year. The two tables are related to each other.

If I choose a number of points with the identify tool and expand the tree in the identify window I can see all the events that are related to a certain point. Is there any way I could make ArcMap sort the related events after year? Right now the list can go 2004, 1973, 1982, 2005 which isn't very pretty.

2

If you right click on the related table, you will find Sort Ascending option as shown below: enter image description here

This should do the job.

3
  • Thank you! This has the side affect of sorting everything in the tree, including the selected points and the related tables. Do you know if it is possible to only sort the related objects? – Anders Jul 13 '15 at 13:23
  • Sorry @Anders, as far as I know this is the only available built-in option. I am looking at how these records are sorted, basically it looks like it sorts according to OID field in descending order except the first item which is the smallest OID. If this is a big inconvenience (either as it is or a global sort of identified items after picking the option in the answer), only workaround I can think of is to use Sort tool. More clearly you can first sort your related table according to your liking (this will be a new table) then relate. – fatih_dur Jul 14 '15 at 11:54
  • OK, good to know. This is absolutely good enough for me - thank you very much. – Anders Jul 14 '15 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.