I am working with some data for property leases in Texas, some of the areas have historic data where it will show all of the owners of the property so when i try and label it some areas will have several names over them. I need to get it to ownly show the newest set of data for each property. The data has an expiration date on the lease for each owner and the leases are connected through a common FID. I was thinking about trying to a definition query to get the latest data out but I cant think of a way that it would work. Any help would be REALLY appreciated.
Thanks
-Rob
Or maybe a simpler way of putting it, would be that for Each FID I need it to show the owner name associated with the newest date